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) Name Is Required

Email (required) Email Is Required Invalid Email Address

Website

Comment Is Required

Notify me of followup comments via e-mail