>How do I select SQL if I want to display all records which contain at least
>one of the values to be compared.
>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?

try :-

select iif(yourfield $ yourlist, yourfield, "") into table yourtable

then
dele all for empty(yourfield)