Thursday, August 16, 2007

[sql] Remove carriage return


UPDATE FooTable
SET FooText = REPLACE(FooText, CHAR(13), '')