am curious.

In which case does

'N' = Type(myField)

fail?



>>>Hello All,
>>>
>>>How determine if a char field in a table contains a number ?
>>>
>>>
>>>Thanks
>>

>>CLEAR
>>CREATE CURSOR crsTest (myField Char(15))
>>INSERT INTO crsTest VALUES([3.50])
>>INSERT INTO crsTest VALUES([-4])
>>INSERT INTO crsTest VALUES([a3.50])
>>INSERT INTO crsTest VALUES([3a.50])
>>INSERT INTO crsTest VALUES([5433.123])
>>INSERT INTO crsTest VALUES([12345.6789])
>>INSERT INTO crsTest VALUES([12.50a])
>>
>>SCAN
>>    ? myField , IIF(ALLTRIM(STR(VAL(myField),15,5)) = ALLTRIM(myField),[ is Number],[ not number])
>>ENDSCAN
>>

>
>This test (wrongly) returns .F. if the input string has a leading "0" ...
>
>-m.