Val function

Official Content
This documentation is valid for:

To convert a number in character format into numeric format.

Syntax

Val(character-expression)

Type Returned:
Numeric N(18.2)

Where:
character-expression
    Must be a Character Expression.

Description

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.

Examples

&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).

Scope

Objects Procedure object, Transaction object, Web Panel object
Languages .NET, Java, Ruby, Visual FoxPro
   

See also

ToNumeric Method
ToString method
Str function





Was this page helpful?
What Is This?
Your feedback about this content is important. Let us know what you think.