USFormat.LongToChar

Converts a character string to a long number.

Returns the result of the conversion as a long number.

Syntax

SELECT USFormat.LongToChar(

          string

,         number-format-pattern

)

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

Example

SELECT USFormat.LongToChar(

         '2'

,        '$$$$999'

)

The return value of this statement is:

$002