get rid of the square brackets around the varchar(255) and it will work fine.

For that matter, why are you putting them around the datatypes anyway? I've never seen anyone do that.

the problem with you original query was precedence

what you need is

WHERE (CHKCANCEL = '0') AND (DITD IS NULL) AND( (CUSTOMERID = '52') OR
(CUSTOMERID = '62') OR
...

don't know if this is what you are looking for or if it will help, but if you call a javascript function via the onload event in the body tag, it will not run until the page is fully loaded.

<body...

I'm assuming you meant 22.00 OR Great and 16.50 OR Greater

double valueAfterDeduction(double oldValue){
if(oldValue >= 22.00) oldValue -= 3.3;
else if(oldValue >= 16.5) oldValue = (oldValue *...