Split alpha-numeric string into multiple columns in SQL Server

To break the string into numerous columns, a certain pattern should be used. Splitting a string can be done using various delimiters such as a comma, semicolon, or tab, or it can be split using the amount of characters provided as input.

Here’s an example of combining a username and a phone number into a string. Our requirement is to divide them into two columns.

CREATE TABLE #Temp(StringData VARCHAR(100));

INSERT INTO #Temp
SELECT ‘Smith9856787901‘
UNION SELECT ‘Will9856787890‘
UNION SELECT ‘Ron9856787891‘
UNION SELECT ‘Roberto9856787899‘
UNION SELECT ‘Fernandes9856787990‘
UNION SELECT ‘Alicia9856789990‘;