Show all Hide all


This function can be used to convert almost any numeric expression (such as an int, a float or a numeric etc.) to a nicely formatted varchar that includes thousand delimiters and the desired number of decimals.

If the desired number of decimals is given as a negative value then the function will behave similar to round() in that the returned value will be an integer rounded to a multiple of 10 or 100 or 1000 etc.

Type: Scalar function
Area of use: General use

Return value: varchar(300)

The string representation of the numeric expression.


@Numeric mandatory numeric(38,12)
The numeric expression to convert.
@DecimalsToDisplay mandatory int
The desired number of decimals.
@LanguageId mandatory int
The language settings to use for the decimal separator and thousand delimiter. Set to NULL or DEFAULT to use the system default language.