Revision as of 14:34, 20 March 2009

VAL()

Class

Expressions and Type Conversion

Purpose

Function to perform character string to numeric conversion

Syntax

VAL(<expC>)

See Also

SET FIXED, SET DECIMAL, INT(), STR(), TRANSFORM(), ROUND()

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

Recital Database Server, Recital Mirage Server, Recital Terminal Developer