Gossamer Forum
(Advanced Search)
for
Home : General : Databases and SQL :

update query that strips linefeeds

Mar 24, 2003, 2:06 PM
hennagaijin
User (425 posts)
Mar 24, 2003, 2:06 PM
Post #1 of 3
Views: 5614
Shortcut
Quote Reply
update query that strips linefeeds
Can anyone tell me how to use an SQL query to update every row of a table, stripping all linefeeds (both \n and \r) from the values in a particular column? I'm sure this is doable, I just can't quite figure it out. Many thanks for your help.
Fractured Atlas :: Liberate the Artist
Services: Healthcare, Fiscal Sponsorship, Marketing, Education, The Emerging Artists Fund
Mar 24, 2003, 2:41 PM
Alex
Administrator (9387 posts)
Mar 24, 2003, 2:41 PM
Post #2 of 3
Views: 5459
Shortcut
Quote Reply
Re: [hennagaijin] update query that strips linefeeds In reply to
UPDATE table SET column = REPLACE(column, "\n", "");
UPDATE table SET column = REPLACE(column, "\r", "");

Cheers,

Alex
--
Gossamer Threads Inc.

Last edited by:

Alex: Mar 24, 2003, 2:42 PM
Mar 25, 2003, 5:39 AM
hennagaijin
User (425 posts)
Mar 25, 2003, 5:39 AM
Post #3 of 3
Views: 5406
Shortcut
Quote Reply
Re: [Alex] update query that strips linefeeds In reply to
Thank, Alex - that did the job!
Fractured Atlas :: Liberate the Artist
Services: Healthcare, Fiscal Sponsorship, Marketing, Education, The Emerging Artists Fund