Originally posted by HDR:
Even if you use CSTR to change to a string, you still need to have a non-numeric included in it. Yes it is a pain, but it is required.
I think it will work with a completely numeric string, but the problem is when the numeric string has leading zeroes. It will work with "12345" but not with "012345" this is very strange. Any idea why it works like this? Any idea where some MS documentation may be located regarding this?