FormatCurrency Function

The FormatCurrency() function returns formatted currency with symbol. It takes one (1) argument to three (3) arguments and returns one formatted currency value. In third parameter -1 can be used.

The syntax for FormatCurrency function is FormatCurrency( Value , [ Decimal Positions ] , [ Culture Name ] ).

        SELECT FormatCurrency(10.257595) /* returns $10.257595 using en-US culture information */ ;
		

SELECT FormatCurrency(10.257595, 10) /* returns $10.2575950000 with 10 decimal positions */ ;

SELECT FormatCurrency(10.257595, 0) /* returns $10 with zero (0) decimal positions */ ;

SELECT FormatCurrency(10.257595, -1, 'en-GB') /* returns £10.257595 using en-GB pound symbol */ ;

SELECT FormatCurrency(10.257595, -1, 'fr-FR') /* returns 10,257595 € with euro formatted currency */ ;

FormatCurrency function provide functionality to add currency formatted values directly from database.