<div>
Thanks for the quick response.
</div>


<div>
<div class="content wysiwyg-content">
I would expect that this:<br />
CASE WHEN [ROUTE] IN ('PO','TOP','INH','TP','VA<wbr />G') THEN CAST(MED_PRICE AS DECIMAL(18,2)) ELSE IV_PRICE END PT_CHARGE_BY_DU<br />
<br />
would not give me 96.8800 <br />
but alas it does
</div>
</div>


I would expect that this:
CASE WHEN [ROUTE] IN ('PO','TOP','INH','TP','VAG') THEN CAST(MED_PRICE AS DECIMAL(18,2)) ELSE IV_PRICE END PT_CHARGE_BY_DU

would not give me 96.8800 
but alas it does

SQL - CAST to two decimal places not working as expexted

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.