Formatting Currency
The following example shows how you can use the FORMAT function to only display whole dollars:
SELECT (FORMAT(netamount,'[>]$999,999')) FROM salesbonus
This SELECT statement displays data as right justified whole dollars, as shown below:
Using FORMAT
Without FORMAT
$176,000
$176,000.00
$87,500
$87,000.00
