USFormat.CharToLong

Previous Next

Converts a character string to a long number.

Returns the result of the conversion as a long number.

Syntax

SELECT USFormat.CharToLong(
          string
,         number-format-pattern
)

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

Example

SELECT USFormat.CharToLong(
         '3,333'
,        '9,999'
)

The return value of this statement is the long number:

3333