>Is there a function that will tell me what field type a memory variable is? I have an activeX control getting information from a spreadsheet and the field type is either character or numeric. I need to know what type it is.
>
>Here is the line that captures the data
>
>Tmp = oXL.ActiveSheet.Cells(TmpSVRow,1).VALUE
>
>I am doing an IF statement and I need it to be a character field. Here is the if statement beginning. I have few lines that are numeric.
>
>IF ALLTRIM(Tmp) = "Runoff Balance Book"
>
>Thanks for your help
>Todd

Todd
Check out

vartype(tmp)
and
type("tmp")