Hi.

I got a database like this
Title | Language
Test1 en
Test2 en
Test3 se

and I want so search on the Title and with a language. Sometimes "en" and "se" and sometime just one language. I created this query but I can't make it work with the "language" selection. Any idéa how to combine several boolean expressions??

Code:
SQL = "SELECT * From Stories"
SQL = SQL & " WHERE Titel LIKE '%" & Request.Form("titel") & "%'"

If Request.Form("swedish") <> "ON" Then SQL = SQL & " AND Language = 'se'"
If Request.Form("english") <> "ON" Then SQL = SQL & " AND Language = 'en'"
Tnx!