Try REPLACE(REPLACE(yourfield, CHR(10), ''), CHR(13), '')

>Hi All, I imported some fox data to Sql Server recently and have noticed some weird looking characters in some of the memo fields - I think they are probably carriage returns / line feeds - any ideas as to how I can get rid of them ?