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