Difference between revisions of "CURRENCY()"
From Recital Documentation Wiki
		
		
		
Helengeorge  (Talk | contribs)  | 
				Barrymavin  (Talk | contribs)   (→Description)  | 
				||
| Line 14: | Line 14: | ||
The CURRENCY() function returns the specified <expN> as a character string prefixed with the current currency character which can be set with the command SET CURRENCY TO <expC>.  The default for SET CURRENCY is "$".  | The CURRENCY() function returns the specified <expN> as a character string prefixed with the current currency character which can be set with the command SET CURRENCY TO <expC>.  The default for SET CURRENCY is "$".  | ||
| + | Note for locale specific settings:  | ||
| + | |||
| + | To change the separator character from a ',' use the SET SEPARATOR TO command.  | ||
| + | |||
| + | To change the point character from a '.' use the SET POINT TO command.  | ||
==Example==  | ==Example==  | ||
Latest revision as of 03:52, 3 June 2011
Purpose
Function to prefix numeric value with currency character
Syntax
CURRENCY(<expN>)
See Also
Description
The CURRENCY() function returns the specified <expN> as a character string prefixed with the current currency character which can be set with the command SET CURRENCY TO <expC>. The default for SET CURRENCY is "$".
Note for locale specific settings:
To change the separator character from a ',' use the SET SEPARATOR TO command.
To change the point character from a '.' use the SET POINT TO command.
Example
set currency to "$" ? currency(88.00) $88.00
Products
Recital Server, Recital