SQL 2000 help with displaying zero decimals
$30-100 USD
Paid on delivery
I have a formula in a money data type field in an SQL 2000 database that calculates a value. Here is the formula that rounds the value to two decimal places:
(round(([retailprice] - [cprice]),2))
As the value is in dollars, I would like to display answers as 12.00 instead of 12. If the answer is 12.63, it correctly displays 12.63. However, ending zeros following the decimal point are dropped. For example, 12.40 appears as 12.4.
I would like a solution by the close of today, March 12, 2004, EST.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
SQL 2000 (SQL Server Enterprise Manager)
Project ID: #3132067