Difference between revisions of "VAL()"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Helengeorge (Talk | contribs) (→Products) |
||
(2 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
− | |||
− | |||
− | |||
− | |||
==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 | + | 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