How to convert text to a number??

I know how to turn a number or date to a text field with the FORMAT command but is there a way to convert a text to a number field?? There are some fields I’d like to total but can’t because their text.

Thanks in advance,


You can use the EVALUATE function for this. See the helpinfo about this function.

Value := ‘010196’;
Ok1 := EVALUATE(VarInteger, Value);
Ok2 := EVALUATE(VarDate, Value);
Ok3 := EVALUATE(VarYesNo, Value);

Use evaluate

if evaluate(Number,Text) then …