Formats a number as a German currency value in SAP SQL Anywhere
This functions takes a number in an SQL Anywhere database and formats it like a German currency value.
- number value is rounded to 2 decimal places
- comma as decimal delimiter
- point as thousand separator
- NO currency sign!
SELECT dba.FormatNumber(12); -- 12,00
SELECT dba.FormatNumber(12.5725); -- 12,57
SELECT dba.FormatNumber(100624.958750); -- 100.624,96
I've taken this example from Volker Barth's post to the SQL Anywhere forum here and reformatted it to my own needs.