Official Content

Converts a number in character format into numeric format.




    Is any valid expression that can involve constants, functions, methods, variables, attributes, Procedures, Inline Formulas. The result must match the character data type.

Type Returned:
Numeric N(18.2)


Objects: Procedure, Transaction, Web Panel, Panel, Data Provider
Generators:.NET, .NET FrameworkJava, Ruby (up to GeneXus X Evolution 3), Visual FoxPro (up to GeneXus X Evolution 3), Apple, Android, Angular


This function converts the numbers of a character expression into a numeric type. It processes the numbers in the character expression from left to right until a non-numeric character is encountered. If the first character of the character expression is not a number, the result of Val function will be 0.


&Result = Val('-123.35')         // Result is -123.35
&Result = Val(STR(123.35, 6, 2)) // Result is 123.35
&Result = Val('ABC')             // Result is 0 (*)
&Result = Val('12A')             // Result is 12 (*)
&WebSesNbr = Val(&SessionId)     // where &WebSesNbr is N(10.0) and &SessionId is C(30)

(*) Converting alphanumerics to numerics is not supported when the method is evaluated in the DBMS (see Server Side Functions/Methods or SAC 42709).

See Also

ToNumeric method
ToString method
Str function

Last update: November 2023 | © GeneXus. All rights reserved. GeneXus Powered by Globant