Difference between revisions of "VAL()"

From Recital Documentation Wiki
Jump to: navigation, search
(Products)
 
(2 intermediate revisions by 2 users not shown)
Line 1: Line 1:
==Class==
 
Expressions and Type Conversion
 
 
 
 
==Purpose==
 
==Purpose==
 
Function to perform character string to numeric conversion
 
Function to perform character string to numeric conversion
Line 12: Line 8:
  
 
==See Also==
 
==See Also==
[[INT()]], [[ROUND()]], [[SET DECIMALS]], [[SET FIXED]], [[STR()]], [[TRANSFORM()]]
+
[[CAST()]], [[INT()]], [[ROUND()]], [[SET DECIMALS]], [[SET FIXED]], [[STR()]], [[TRANSFORM()]]
  
  
Line 32: Line 28:
  
 
==Products==
 
==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+
Recital, Recital Server
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Functions]]
 
[[Category:Functions]]
 +
[[Category:Expressions and Type Conversion]]
 +
[[Category:Expressions and Type Conversion Functions]]

Latest revision as of 16:51, 8 December 2009

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

Recital, Recital Server