>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