Database

select 28.50 - ROUND(28.50 * 0.25, 3)  returns 21.375 (which will round up to 21.38)
select Round(28.50 - ROUND(28.50 * 0.25, 3),2) returns 21.38 (rounds up to 21.38)
If the precision in the rounding is chaged to 2 for the 'price*percent' term:
select 28.50 - ROUND(28.50 * 0.25, 2) returns 21.37
select Round(28.50 - ROUND(28.50 * 0.25, 2),2) returns 21.37

myNameIsRon wrote:

It looks like I shouldn't use ROUND, in my SQL because I'm wanting cash register type of rounding (always round up). It's too bad they don't have parameter options to select the type of rounding you want.

select Round(1.5,0,0)  -> 2.0 round up .5+
select round(2.5,0,0)  -> 3.0 round up 2.5 and greater
select round(2.4,0,0)  -> 2.0 round down 2.0 to 2.5 exclusive
select Round(1.5,0,1)  -> 1.0
select round(2.5,0,1)  -> 2.0

myNameIsRon wrote:

really don't want Bankers Rounding (even # to round up):

use pubs
select substring (phone,charindex('-',phone)+1, Len(phone)-charindex('-',phone)+1) 
from 
authors