Version: 10.1

USFormat.LongToChar

note

This article is about the LongToChar method of the USFormat internal component.

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 IO formats 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

USFormat.LongToChar​