Remove any leading or following spaces as well as any carriage returns

posted on December 05, 2018 08:05

UPDATE YourTable
SET YourColumn = RTRIM(LTRIM(REPLACE(REPLACE(YourColumn, CHAR(10), ''), CHAR(13), '')))

Posted in: SQL Scripts

Actions: E-mail | Permalink | Comments (0)

Post Rating

12345

There are currently no comments, be the first to post one!

Only registered users may post comments.

120 OLD FREEMANS WAY, BREWSTER, MA 02631
MAILING: P.O. BOX 2342, BREWSTER, MA 02631
PHONE (774) 323-3176