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
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