ramziahmad
IS-IT--Management
is there any limitation as to number of OR operator in the WHERE statement? what is it (if any)?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
any limit to no. of "or" oper in WHERE clause?
- Thread starter ramziahmad
- Start date
- Status
I don't think there is a specific limit (I tested a SQL stmt that has nearly 200), but I think the limit is for the entire SQL statement. (I want to say it's 4K - at least that's what sticks out in my mind....I'd have to look it up) J. Jones
jjones@cybrtyme.com
jjones@cybrtyme.com
- Status
Similar threads
- Locked
- Question
- Locked
- Question