USFormat.LongToChar

Previous Next

Converts a long number to a character string.

Returns the result of the conversion as a string.

Syntax

SELECT USFormat.LongToChar(
          long-number
,         number-format-pattern
)

 

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

Example

SELECT USFormat.LongToChar(
         2
,        '$$$$999'
)

The return value of this statement is the following string value, which starts with 3 spaces:

   $002