I have an SQL search that is converting two values to type money. I want it to show two digits after the decimal point but am getting inconsistent results. The first value is as follows:
cast(tblInventoryItem.itemcost as money) as originalcost
This displays correctly i.e. 2000.00 or 150.70 etc
The second value is this:
cast (tblInventoryItem.itemcost + tblUpgrades.ItemCost as money)) as totalcostincupgr
But this displays as 2000 or 150.7
How can I get the second value to show two decimal places even when the digits are zeros?