>>Hi everyone,
>>
>>I have a simple problem, but I want to solve it the best way, because I want to use it in a long scan loop. I have fields in a table called Low and High (8 char). I want to translate them into numbers. Val function would not give me correct results, if these fields contain non digit info. I'm not absolutely sure, how should I treat fields with non-digit chars in them.
>>
>>Suppose, I want to treat them as 0. What would you suggest?
>>
>>Thanks in advance.
>
>Give this a try ...
>
>

>IF TRANSFORM(VAL(cLowValue)) == ALLTRIM(cLowValue)
>  nLowValue = VAL(cLowValue)
>ELSE
>  nLowValue = 0 && or skip them or do whatever else you want to do with non-numeric data
>ENDIF
>

>
>Cathy

Thanks, Cathy. This seems to be the best idea.