Kathy,
It is Boolean logic as implemented by you favorite SQL optimizer. X or Y and Z == x or ( y and z) because AND has a higher precedence than OR. John _____ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Kathy Morris Sent: Tuesday, May 20, 2008 8:27 PM To: [email protected] Subject: Qualification Error - Strange? Hello all, I ran this qualification: 'Assignee+' = "Michael Davis" OR 'Assignee+' = "Gurpreet Savi" AND 'Status*' <= 3 Result: status values that such as Closed and Cancelled appeared that have a value of 5 and 6?? When I modified the qualification: ('Assignee+' = "Michael Davis" OR 'Assignee+' = "Gurpreet Savi") AND 'Status*' <= 3 Result: the values that were less than or equal to 3 appeared correctly. What logic is this based on? Sometimes when I use LIKE %Mary Smith I find the name faster than if I type = "Mary Smith" - never understood why. _____ Wondering what's for Dinner Tonight? Get new <http://food.aol.com/dinner-tonight?NCID=aolfod00030000000001> twists on family favorites at AOL Food. __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" html___ E-mail message checked by Internet Security (5.5.0.191) Database version: 5.09860 http://www.pctools.com/Internet-Security/ E-mail message checked by Internet Security (5.5.0.191) Database version: 5.09860 http://www.pctools.com/Internet-Security/ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
