Limitation of OR operator 1

[Maii]

I have build SQL query using OR operator
Such as
SELECT COMPNAYNAME FROM CUSTOMERS WHERE (CUSTOMERID =
‘AAAAA’)
OR (CUSTOMERID = ‘BBBBB’).............
It has been fail when I add more then 180 OR operators.
Are there any limitation and alternate solutions?

Thanks in advance
maii

 

[dbomrrsm]

SELECT COMPNAYNAME
FROM CUSTOMERS
WHERE CUSTOMERID IN
(‘AAAAA’,‘BBBBB’,'CCCCC'........)

Even better the IN can be used with a select from another table:

SELECT COMPNAYNAME
FROM CUSTOMERS
WHERE CUSTOMERID IN
(SELECT CUSTOMERID FROM ANOTHER_CUST_TABLE)

[blue]DBomrrsm[/blue]

[blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]

 

[vongrunt]

... especially with 180+ customers to check.

Simple question - simple and efficient answer.

------
heisenbug: A bug that disappears or alters its behavior when one attempts to probe or isolate it
schroedinbug: A bug that doesn't appear until someone reads source code and realizes it never should have worked, at which point the program promptly stops working for everybody until fixed.
[ba

 

[dbomrrsm]

Cheers Vongrunt

[blue]DBomrrsm[/blue]

[blue]Software code, like laws and sausages, should never be examined in production[/blue][black] - [/black][purple]Edward Tenner[/purple]