> I made a table which have a field of keywords. > The Keywords are those to be used as a clue values when I query. > They are several comma-delineated clue words such as > - shoes,nike,addidas,sports,snickers,health - > In case I want to search all the records which contain word "sports" in > any > place of keyword field, How do I do that? > I'd like to make an search form similar to the Yahoo, Infoseek.... > Would you please help me out? sele * where keyfield like "%sports%" into ... As far as I can recall, % and _ are SQL ... LIKE wildcards corresponding to * and ? in filespec syntax. For a phonebook app I've used a separate table containing keywords and pointers to the master table, indexed on keywords. Used it for incremental search, mostly, but can be easily used for queries.