USFormat.DoubleToChar

Converts a numeric value of type double to a character string.

Returns the result of the conversion.

Syntax

SELECT USFormat.DoubleToChar(

          double

,         number-format-pattern

)

Both double and number-format-pattern are required. Number-format-pattern must be one of the USoft format patterns used for number values.

Example

SELECT USFormat.CharToDouble(

         '1234.56'

,        '9,999.99'

)

The return value of this statement is the number:

1,234.56