Home Forums SQL Server 2012 SQL Server 2012 - T-SQL t-sql 2012 split function RE: t-sql 2012 split function
Lynn Pettis
SSC Guru
Points: 442467
More actions
December 19, 2017 at 2:37 pm
#1972813
Not sure, the following works for me:declare @ssGrade VARCHAR(8000) = 'PK,KG,01,02';SELECT * FROM fn_splitString(@ssGrade);
declare @ssGrade VARCHAR(8000) = 'PK,KG,01,02';SELECT * FROM fn_splitString(@ssGrade);
Doing the insert into a temp table works as well.