Sean is quicker typing 😀

DECLARE @STRINGS TABLE

(

MYID INT IDENTITY(1,1) NOT NULL

,MYSTRING CHAR(4) NOT NULL

)

INSERT INTO @STRINGS (MYSTRING)

SELECT MYSTRING FROM

(VALUES ('02yC'),('12G8'),('9Pp1'),('7@uL')) AS X(MYSTRING);

;WITH NX(N) AS (SELECT N FROM (VALUES

(1),(1),(1),(1),(1),(1),(1),(1),(1),(1)) AS X(N))

,NUMBERS(N) AS

(

SELECT ROW_NUMBER() OVER

(ORDER BY (SELECT NULL)) AS N

FROM NX N1,NX N2

)

SELECT

MYID

,(SELECT

UNICODE(SUBSTRING(MS.MYSTRING,NM.N,1))

FROM @STRINGS MS

CROSS APPLY NUMBERS NM

WHERE NM.N <= LEN(MS.MYSTRING)

AND MS.MYID = MMS.MYID

FOR XML PATH(''),TYPE).value('.[1]','VARCHAR(100)') AS NUMSTR

FROM @STRINGS MMS

😎