to_char
Converts an expression to a character string.
Available in:
| Apps (win) |
Apps (char) |
Reportwriter |
RPC |
Standalone PL |
| X |
X |
X |
X |
X |
Syntax
string to_char(data[,format])
expr data
string format
Description
|
data | specifies the expression to convert.
If data is already a char, no conversion takes place.
|
|
format | (optional) specifies a mask. If none is provided,
a default conversion is performed. Refer to the
VORTEX Installation and Usage Guide for the valid formats.
|
Example
Format salaries with two decimal places and a currency symbol.
field = to_char(SAL,"$99,999.99");