>>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)
Depending on how big your look-up needs are... you may want to investigate a third party product. Like the one MT uses here, Phd... But, if you are only going to have a few look-ups instead of hundreds, the above approach would be the way to go...
Steve Medvid
Systems Analyst
Environmental Resource Management