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
P. O. BOX 2342, BREWSTER, MA 02631
(774) 323-3176
CONTACT US