Code to isolate the 4,5and 6 digit in phone number 1

[noslo]

Hello All,

Please bear with my basic request. I am new to SQL Server.

I am trying to create a column from a phone number column.
I am trying to isolate the 4, 5 and 6th digit in a phone number.
Ex:[PhoneNumber] = 3135551212 New Column = 555

What code would I use?

Thanks for your patience and help.

Helen

 

[nefou]

Try that:

SELECT substring(PhoneNumber, 4, 3) FROM your_table

Shoud do what you need it to do

smg