@PARSE_FORMATTED_DECIMAL
The PARSE_FORMATTED_DECIMAL function
converts the given string into a decimal. It takes up to two optional
parameters that are used for deciphering the format of the number
stored in the string.The first parameter is the value to be
converted and is required. This parameter is evaluated as a string,
and a decimal is created from it using the optional parameters or
the client’s locale. This string must be a valid representation
of a decimal.
Parameters
- @PARSE_FORMATTED_DECIMAL
(String [, Decimal Point, Thousands Separator])
- String Required string parameter, contains the value to be parsed interpreted as a string and parsed into a decimal by the function.
- Decimal Point Optional string parameter with a default value of the client’s locale decimal separator. This value may be set to any single character to be considered as a decimal separator.
- Thousands Separator Optional string parameter with a default value of the client’s locale thousands separator. This value may be set to any single character to be considered as separating thousand and hundreds, millions and hundred thousands, etc.
Supported Return Types
Decimal