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