Version: 10.1

USFormat.CharToDouble

note

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

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

Returns the result of the conversion as a number.

Syntax

SELECT USFormat.CharToDouble(
*string*
,         *number-format-pattern*
)

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

Example

SELECT USFormat.CharToDouble(
         '3,333.93'
,        '9,999.99'
)

The return value of this statement is the number:

3333.93

USFormat.CharToDouble​