Searching character in Specific Position - SQL Server

Question

Hello, can anyone help me? I am building a query and I came across some problems in the way the bank was structured. I have a base with several phone numbers, and I need the 5°digito to be = 9. I have done a LEN(Phone) = 14 to identify only cell phones, so simplifying I need to put in my Where to bring only where the 5th digit is 9

Answer 1

SELECT telefone,   
FROM 'Sua Tabela'
WHERE SUBSTRING(telefone, 5, 1) = 9;

I’m not sure if it will work because at the moment I don’t have my laptop.