Difference between revisions of "VAL()"

Revision as of 08:31, 4 February 2013

Purpose

Function to perform character string to numeric conversion

Syntax

VAL(<expC>)

See Also

CAST(), INT(), ROUND(), SET DECIMALS, SET FIXED, STR(), TRANSFORM()

Description

The VAL() function converts the character expression <expC> into a numeric value. If SET FIXED is on, then the value of the string will be rounded to the nearest decimal place according to the SET DECIMALS command.

Example

string = "1234"
? val(string)
      1234
set decimals to 2
set fixed on
? val("678.7615")
    678.76

Products

Lianja, Lianja Server