T-SQL Simple Two Decimal Places
Posted on 2014-04-11
I can't believe that I can't find a simple example of this on the internet, somewhere.
All I want is the number 64.25--not 64 and certainly not 64.00.
The best that I can come up with is the following, and it is giving me 64:
CAST(UPR30301.MTDHOURS_4/100 AS DECIMAL(18, 2))
How do I take "UPR30301.MTDHOURS_4/100" and have the result be 64.25? That's all I want. It should be very simple.