The result of the following statement:
SELECT SUM(Salary) (FORMAT '$$99,999.99') FROM Employee;
is:
SUM(Salary) ----------- $851,100.00
FORMAT phrases, by themselves, cannot cause conversion of character to numeric data, or numeric to character data. An error message is returned if a FORMAT phrase implies data conversion.