how to split comma separated values in sql without function

Rohan Gupta

Jun 29 2015 3:06 AM

545

DECLARE @list VARCHAR(MAX)

SELECT @list = COALESCE(@listStr+',' , '') + columnname

FROM tablename

SELECT @list

Answers (2)

Next Recommended Forum