How to get rid of the zeros in money type,
i.e. only show dollars, no cents?
I use:
CONVERT(varchar, Price, 1) AS Price
It gives me the result with 2 digits decimals. like 123,456.00
I only need the dollar part, how to get rid of the zeros, Thanks!
CONVERT(int, a) AS Price
CONVERT(numeric, a) AS Price
Also take a look at the following for CAST and CONVERT
http://msdn2.microsoft.com/en-us/library/ms187928.aspx
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_ca-co_2f3o.asp
|||Consider the functions CEILING() and FLOOR().
Zlatko
