TRIM function?

[terp_in_umcp]

Heres the situation:

In my column in the database, the value is either "NEW" or "NEW "....notice the 2 extra spaces at the end...so when I do a condition check, it works for those tht have "NEW" btu doesnt if its "NEW "

Is there some TRIM function to get rid of the 2 spaces when they appear...

mysql="SELECT * FROM Test WHERE number='10'"
Set rs= Con.Execute( mySQL )


if rs("status")="NEW" then
...
else
...
end if

A silly fix that I did is just put an or rs("status")="NEW " in it...any better ideas???

[glenngv]

You already mentioned it.
if Trim(rs("status"))="NEW" then

[terp_in_umcp]

Thanks works like a charm:

So Trim(string) removes spaces on both sides of a string...good info:)

[glenngv]

Yeah, Trim(String) removes spaces on both sides of the string. LTrim(String) trims the left side and RTrim(String) the right side.

[degsy]

Just for reference
http://www.w3schools.com/vbscript/vbscript_ref_functions.asp