>>Hi All:
>>
>>Do you have an easy way for testing if a character field contains valid numeric data.
>>
>>Someone suggested:
>>
>>

>>IF TRANSFORM(VAL(m.luValue)) == m.luValue
>>

>>
>>but this doesn't work every time. e.g. when luValue = '08'
>>
>>Thanks,
>>
>>Yossi
>
>Type(myTable.MyField) = 'N'

Thanks, it seems to work.

So then the VFP help file is wrong (gasp!) when it says in the entry on TYPE():

"VARTYPE( ) is similar to the TYPE( ) function, but VARTYPE( ) is faster and does not require quotation marks ("") to enclose the specified expression."

Consider:

x = '0.8'
? TYPE(x)   &&returns "N"
? VARTYPE(x)   &&returns "C"