VAL

Action

Returns the numeric value of a string.

Syntax

VAL ("string")

Parameter

String

The string whose numeric value you want to discover. By default, Val expects the string to be in decimal format. To determine the numeric value of a hexadecimal string, start the string with an ampersand ‘&’.

Returns

The numeric value of the input string.

 

Examples

$x = VAL(SUBSTR(@IPADDRESS0, 1, 3))

$x = VAL("&A34")