Pages

Tuesday, September 20, 2011

How to strip spaces.

UPDATE [TABLE]
SET [COLUMN] = LTRIM(RTRIM([COLUMN]))
WHERE LEN([COLUMN]) <> DATALENGTH([COLUMN])
Posted by Albert Lau at 9/20/2011 10:39:00 AM

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)