multiple OR's and one AND 2

[ivow]

Hi All,
I have statement like this:

SELECT * FROM table1 WHERE lang="English" OR lang="French" OR lang="Spanish"
AND title LIKE '%" & variable & "%' ORDER BY Lang, Sort1byMan, Product,
Sort2byCurrent, Sort3byLevel

What I'd like out of this is:
everything that contains the text from 'variable' from table1 in French,
Spanish and English.
What I get:
everything from table1 in French and English, and everything that contains
the text from 'variable' only from Spanish.

How could I "fix" my sql statement to do this?


Ivo
"If it's stupid but works, it isn't stupid."

 

[MeanGreen]

Try this:

SELECT * FROM table1 WHERE (lang="English" OR lang="French" OR lang="Spanish")
AND title LIKE '%" & variable & "%' ORDER BY Lang, Sort1byMan, Product,
Sort2byCurrent, Sort3byLevel

Hope this helps.

 

[ivow]

sweet! that was good! thanks. "If it's stupid but works, it isn't stupid."

 

[SQLBill]

Remember, unless you 'force' it by using parenthesis the order of precedence for LOGICAL operators is AND, then OR, then NOT.

Ref: See Books OnLine, Index search on "logical operators, AND".

-SQLBill

 

[fluteplr]

This works the same but is a lot easier to read.

SELECT * FROM table1
WHERE lang in ("English","French","Spanish&quot
AND title LIKE '%" & variable & "%'
ORDER BY Lang, Sort1byMan, Product,
Sort2byCurrent, Sort3byLevel