Skip to content
Advertisement

Reduce decimal places in SQL queries

All my SQL queries return numbers with multiple decimal places. Queries similar to the below which returns an output of $37508.9845264100. How can I reduce the decimal places to 2?

Advertisement

Answer

The FORMAT function is probably the closest fit to what you want here:

The mask C2 being used above means format as a currency with two decimal places of precision.

User contributions licensed under: CC BY-SA
2 People found this is helpful
Advertisement