Because I was trying to detect it, not convert it. If it's not a number
then it's a string or date, in which case I replace single-quotes in the
string with two single-quotes, and encapsulate the string with
single-quotes, to prepare it for import into SQL Server.
Bah.. prolly more info than you wanted to know. :)
Jon
Quote:
> why not simply do a val or a CInt on the variant to force an interger
> conversion?
> >Does anyone know how to detect whether the value of a variant is an
integer
> >as opposed to the ascii character combination of a number?
> >Thanks,
> >Jon
Integer or "integer"??