Available for SQL 2016 and above.
SELECT value
FROM STRING_SPLIT('abc, def, klasdklas, lkdld', ',')
WHERE value IS NOT NULL
AND RTRIM(value) <> '';
https://msdn.microsoft.com/en-us/library/mt684588.aspx
Available for SQL 2016 and above.
SELECT value
FROM STRING_SPLIT('abc, def, klasdklas, lkdld', ',')
WHERE value IS NOT NULL
AND RTRIM(value) <> '';
https://msdn.microsoft.com/en-us/library/mt684588.aspx