Forum: MS SQL  May 9th, 2008 |
| Replies: 1 Views: 1,396 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. |
| Forum: MS SQL Sep 12th, 2006 |
| Replies: 3 Views: 4,720 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
... |
