views:

42

answers:

0

Hello,

i got some problem with replacing a CarriageReturn (CR) to a CarriageReturn LineFeed (CRLF) entry´s in a textfield on MS SQL 2005 System.

There´s a table "notice" where a textfield "desc" is filled with some content which contains some CR. So some example is:

Mister Smith "CR" Road 123 "CR" Germany

I try to replace the CR with a CRLF by some update statements but it isn´t working so far.

Update notice
SET desc = REPLACE(CAST(desc as varchar(8000)), CHAR(13), CHAR(13) + CHAR(10))

Any one of u have some idea, how i can replace a CR with a CRLF in a textfield?

Thanks