Difference between revisions of "CURRENCY()"

From Recital Documentation Wiki
Jump to: navigation, search
 
(Description)
 
(3 intermediate revisions by 2 users not shown)
Line 1: Line 1:
==Class==
 
Numeric Data
 
 
 
 
==Purpose==
 
==Purpose==
 
Function to prefix numeric value with currency character
 
Function to prefix numeric value with currency character
Line 18: 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==
Line 28: Line 29:
  
 
==Products==
 
==Products==
Recital Database Server, Recital Mirage Server, Recital Terminal Developer
+
Recital Server, Recital  
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Functions]]
 
[[Category:Functions]]
 +
[[Category:Numeric Data]]
 +
[[Category:Numeric Data Functions]]

Latest revision as of 03:52, 3 June 2011

Purpose

Function to prefix numeric value with currency character


Syntax

CURRENCY(<expN>)


See Also

SET CURRENCY


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