Delphi Val function

Here Val and IIf are the functions in the database you are using
In Delphi, Val is a function that converts a string to a number.
Val (S; var V; var code:integer) The first argument is the string to be converted, the second argument holds the converted number, can be an integer or a floating point, and the third parameter holds the character index value of the error, for example:
Var
V, Code:integer;
Begin
Val (' 123.445 ', v,code);
End

After conversion: V = 123, Code = 4, representing the string ' 123.445 ' converted to an integer is 123, error in string 4th bit conversion

Delphi Val function