Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Line break in string field

Author  Topic 

adlo
Posting Yak Master

108 Posts

Posted - 2004-08-31 : 13:22:23
Does anyone know how to replace a linebreak (Char(13)+ Char(10))with '<br>' in a string field?

Seventhnight
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2004-08-31 : 13:23:38
Select fieldName = Replace(fieldName,char(13)+char(10),'<br>')

Corey
Go to Top of Page

adlo
Posting Yak Master

108 Posts

Posted - 2004-08-31 : 13:33:07
Thanks
Go to Top of Page
   

- Advertisement -