Home Forums Article Discussions Article Discussions by Author Discuss content posted by sknox STRING_SPLIT with no delimiter RE: STRING_SPLIT with no delimiter
Carlo Romagnano
SSC-Insane
Points: 22601
More actions
December 11, 2017 at 1:00 am
#1971502
Good to know!I would add a where clause to avoid empty stringDECLARE @a VARCHAR(6) = 'ABCDEF'SELECT value FROM STRING_SPLIT(CAST(CAST(CAST(@A AS NVARCHAR) AS VARBINARY) AS VARCHAR), CHAR(0)) WHERE value <>''
DECLARE @a VARCHAR(6) = 'ABCDEF'SELECT value FROM STRING_SPLIT(CAST(CAST(CAST(@A AS NVARCHAR) AS VARBINARY) AS VARCHAR), CHAR(0)) WHERE value <>''