Function Real2str

Real2str

FUNCTION Real2str(IN r REAL, IN prez SMALLINT) RETURNS CHAR(n);

Parameters

r	value to be converted
prez	conversion type

Description

The Real2str function converts the value specified by the first parameter into character strings and returns the string. The prez value is interpreted as follows:

- if prez equals 99, the string will be written as literal in SQL language; otherwise
- the absolute value of prez specifies the decimals count;
- if prez is positive or 0, the result will be in semialgorithmic notation;
- if prez is negative, the result will be in decimal notation.

There is also a special format called account notation - decimal notation, where thousands are separated with the separator character set in Windows. The account notation has value 100+(count of decimals).

If the conversion is done on the server, the decimal separator will be the dot character (always). The separator may be globally modified using the server property DecimalSeparator. If you wish to use the separator set in the operating system for the specified language, assign empty value into this property.

You may also use the CAST function for conversion.

Function value

This function returns the character string, which is the decimal notation of the r number.

See