if select a field with 0 we don't want to see .00

[solo1234]

Dear all,

We are busy with selecting a a table with data type Money and using the next statement:

SELECT CASE moneyFld WHEN 0 THEN 0 ELSE Cast(moneyFld as Numeric(10,2)) END AS moneyFld from tbl_x

Field values zero are displayed as ".00", can someone tell us how to show a real zero? ("0")

Nice regards,
Ton.

 

[RiverGuy]

This is a job for your front end display (Excel, reporting software, etc.). The scale of the decimal column of your result set will be consistent across all rows, as it should be. The only way I can think of to do what you are asking is to cast the column to a char/varchar datatype and add some string manipulation logic.