Is it possible to exclude records in an sql statement such as:
"SELECT * WHERE casenumber = casenumber AND casetype NOT 'DUI'"

I have a large database I have to query and I want to exclude a certain case type.

Certainly. I am not sure what database you are using or what your code looks like so I am not sure what difficulty you are using. I might point out you are missing a FROM clause in your sql statement, which I believe is almost always necessary. If you post some code, I might be able to give more pointers.

Yehuda

Thanks. Basically, the code I listed was just a generalization. The exact query is:

  Dim objRS, objComm, strName
  strName = Replace(UCASE(Request.Form("name")), "'", "''")

  Set objComm = Server.CreateObject("ADODB.Command")
  objComm.ActiveConnection = strConnect
  objComm.CommandText = "SELECT name, case_number, case_subtype From ITDTRF01 WHERE name LIKE '" & strName & "%' " & _
                        "AND case_subtype NOT 'DUI'"
  objComm.CommandType = adCmdText
  Set objRS = objComm.Execute
  Set objComm = Nothing


("AND case_subtype NOT 'DUI'") This is the part that I'm questioning.

this should work:
AND NOT case_subtype = 'DUI'

Ahhh... Had it backwards. Worked like a champ! I really appreciate the help!

No problem, glad we could help.

Alternately, it can also be written as:

AND case_subtype <> 'DUI'

Cheers!

_________________________
- Vijay G
Strive for Perfection