Tuesday, May 10, 2005

Remove Spaces - TRIM

There is no single function to remove leading and trailing spaces from the field. For this you need to:

Remove Training spaces using LTRIM(<column>)
Remove Leading spaces using RTRIM(<column>)


SELECT LTRIM(RTRIM(<column>))

posted by Chandra Ananthapatnayakuni @ 5/10/2005 10:02:00 PM

0 Comments:

Post a Comment

<< Home