Snippets

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)

12345

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

Name (required)

Email (required)

Website

Notify me of followup comments via e-mail