Difference between revisions of "VAL()"
From Lianjapedia
m (Text replace - "Recital" to "Lianja") |
Helen.george (Talk | contribs) |
||
Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Function to perform character string to numeric conversion | Function to perform character string to numeric conversion | ||
− | |||
==Syntax== | ==Syntax== | ||
VAL(<expC>) | VAL(<expC>) | ||
− | |||
==See Also== | ==See Also== | ||
[[CAST()]], [[INT()]], [[ROUND()]], [[SET DECIMALS]], [[SET FIXED]], [[STR()]], [[TRANSFORM()]] | [[CAST()]], [[INT()]], [[ROUND()]], [[SET DECIMALS]], [[SET FIXED]], [[STR()]], [[TRANSFORM()]] | ||
− | |||
==Description== | ==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. | 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== | ==Example== | ||
Line 25: | Line 21: | ||
678.76 | 678.76 | ||
</code> | </code> | ||
− | |||
==Products== | ==Products== |
Revision as of 11:26, 12 December 2012
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