Taking out unwanted 0's
In the number column, we created a statement of 'CASE WHEN CAST(number as char) = 0 THEN ' ' ELSE CAST(Number as Char) END'. The statement works for the number column. We need the currency column to be in a normal us dollar format ($1.00), but using the same logic above takes away the dollar format.
Any ideas on how to make this work?
Thanks.