> Is there a easy way to get rid of the cents do the display > shows $10 instead of $10.00? I can't fit all the columns > on the page.
>From the help on FORMAT: SELECT (FORMAT(netamount,'[>]$999,999')) FROM salesbonus (remember to include enough 9s for the largest sum you may have). -- Larry
