how to split comma separated values in sql without function

Question

DECLARE @list VARCHAR(MAX) SELECT @list = COALESCE(@listStr+',' , '') + columnname FROM tablename SELECT @list

Sibeesh Venu · Answer

Hi, Is that a question or Are you facing any issues to do this?   Kindest Regards Sibeesh Venu www.SibeeshPassion.com

Pankaj Kumar Choudhary · Answer

hello @Rohan you can refers these sites   http://blog.sqlauthority.com/2015/04/21/sql-server-split-comma-separated-list-without-using-a-function/   http://forums.asp.net/t/1965445.aspx?How+to+split+a+comma+separated+value+to+columns+in+sql+server   http://stackoverflow.com/questions/10581772/how-to-split-a-comma-separated-value-to-columns