Determine type of Value

[Shahid Juma]

Hello All,

This may be a trivial question, but I was wondering how can you determine if
a value contains an Integer or Float. I know there is a function called
IsNumeric, however you can't determine what type it is.

Thanks for the help,
Shahid

 

[Bob Barrows [MVP]]

Hello All,

This may be a trivial question, but I was wondering how can you
determine if a value contains an Integer or Float. I know there is a
function called IsNumeric, however you can't determine what type it
is.

Thanks for the help,
Shahid

If Int(val) = val then
'It's an integer
Else
'It's a float
End if

Bob Barrows

 

[Shahid Juma]

Thanks,

A follow up to this question. How can you determine what type of variable it
is from the record set. If you have a query that looks at a table in SQL
Server. How can you tell that a certain field is varchar, bigint, int, etc?
The reason for asking is that I need to know what type of variable it is and
sometimes these fields are empty so using the value to determine what type
won't work every time.

Thanks,
Shahid

 

[Mark Schupp]

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/ado270/htm/mdprotype.asp

--
Mark Schupp
Head of Development
Integrity eLearning
www.ielearning.com