View Single Post
  #3 (permalink)  
Old 06-23-2008, 02:20 PM
jeterry jeterry is offline
Junior Member
 
Join Date: Feb 2008
Location: Lubbock, TX
Posts: 20
Wink SQL Filter

I tried this on a SQL database and it worked for me.

select * from inventory where description like '%Milk%' and description like '%GOAT%'

yielded one record with milk and goat in the description.

also tried it with OR and had all of the records with milk in the description and one goat.

To filter you must use the percent sign as shown

Hope this is what you are looking for
Reply With Quote