2
Reply

how to split comma separated values in sql without function

Rohan Gupta

Rohan Gupta

Jun 29 2015 3:06 AM
547
 DECLARE @list VARCHAR(MAX)
SELECT @list = COALESCE(@listStr+',' , '') + columnname
FROM tablename
SELECT @list

Answers (2)