SQLTeam.com | Weblogs | Forums

How to insert a line break in a SQL Server VARCHAR/NVARCHAR string


#1

Hi ALL,

My table one column have a string like
'Hai,Hello,How are you,Hai all'

but when we select the column that time i want display the string like

1.Hai
2.Hello
3.How are you
4.Hai all

please help me asap


#2

Please look at Splitter