Saturday, April 26, 2014

New line for Text in a row

Use a replace function to insert a line break with char(10)+char(13).



declare @s varchar(4000)='Email:abc@xyz.com---Wesleyan University,Bachelors,1986---University of Virginia School of Law,Doctor of Jurisprudence,1991---French,Working---Italan,Fluenty---Phone:zzz zzz zzzz'

select replace(@s,'---',char(10)+char(13))


No comments:

Post a Comment