Difference between revisions of "VAL()"
From Lianjapedia
Helen.george (Talk | contribs) |
Helen.george (Talk | contribs) |
||
Line 26: | Line 26: | ||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
− | [[Category: | + | [[Category:Formatting Functions]] |
− | + |
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