Trim

consulting · Post by **consulting** » Thu Nov 27, 2008 12:03 pm

How to remove the whitespace.
My need is i am having number 00123654(space is included before) because of it the last number 4 is skipped i have to remove the space to get last 4 also i tried with trim and stripwhitespace

ray.wurlod · Post by **ray.wurlod** » Thu Nov 27, 2008 5:13 pm

What is the data type?

Shruthi · Post by **Shruthi** » Fri Nov 28, 2008 12:56 am

TrimLeadingTrailing command will remove the spaces in the beginning and end for the datatype char or varchar.

StripWhiteSpace function will remove all the spaces in the string. Even if theer are spaces in between, those will be removed

ray.wurlod · Post by **ray.wurlod** » Fri Nov 28, 2008 8:52 pm

Yes, but if the data type is Char, then pad characters will be written back. Hence my question about data type.