CODE EXAMPLE FOR SQL

dollar format in sql server

SELECT FORMAT(1234, 'C') Result;
-- Result : $1,234.00 

SELECT FORMAT(1234, 'C0') Result;
-- Result : $1,234 

SELECT FORMAT(1234, 'C4') Result;
-- Result : $1,234.0000 

SELECT FORMAT(1234, 'C', 'fr-FR') Result;
-- Result: 1 234,00 €