Results 1 to 7 of 7
Thread: OR problem
Jan 7, 2005, 10:07 #1
- Join Date
- Jan 2004
- 0 Post(s)
- 0 Thread(s)
I need some help with this query:
WHERE active = '1'
OR fname LIKE '%#FORM.search#%'
OR sname LIKE '%#FORM.search#%'
OR company LIKE '%#FORM.search#%'
I would like to select all records which have an active setting of 1 and match the form search submission. The problem is its selecting anything with an active status of 1 or a match to the form search submission.
Any help would be much appreciated,