SQL Statement - what the

Hey All,

Any idea what's wrong?
Half asleep i know i've missed something.

VB Code:

strSQL = "Select * FROM tbl_Part WHERE [Model] LIKE '%" & Replace(varSearch, "'", "''") & "%' " _
        & "OR PartNumber LIKE '%" & Replace(varSearch, "'", "''") & "%' " _
        & "OR Description LIKE '%" & Replace(varSearch, "'", "''") & "%' " _
        & "AND Country ='Australia';"

This returns all records regardless of the Country??

Put all the ORs in brackets:

Code:

---

strSQL = "Select * FROM tbl_Part WHERE ( [Model] LIKE '%" & Replace(varSearch, "'", "''") & "%' " _
                & "OR PartNumber LIKE '%" & Replace(varSearch, "'", "''") & "%' " _
                & "OR Description LIKE '%" & Replace(varSearch, "'", "''") & "%' " _
                & ") AND Country ='Australia';"

---

Yes, that is correct. You have OR statement in there....you need to put brackets around them, ie:

Code:

---

SELECT *
FROM tblUsers
WHERE (Username = 'Moose' OR Username = 'Badger') AND Banned = 0

---

Does that help?

Woka

Beautiful thanks guys.

Too many things going on shoulda known that. :)

b :)

:confused:
RESOLVED ?
:confused: