Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Removing new line character

0 views
Skip to first unread message

Maziar Aflatoun

unread,
Jul 16, 2005, 12:49:10 AM7/16/05
to
Hi,

Does anyone know a SQL statement that would remove all the \r\n (new line
character) from a column in the database (if it exists)?

Thanks
Maz.


ambr...@hotmail.com

unread,
Jul 18, 2005, 7:25:10 AM7/18/05
to
Hi Maz

Try something like

UPDATE MyTbl
SET MyColumn = replace(MyColumn, char(13) + char(10), '')


Regards
Alan

0 new messages