>>>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...
If I understand your question you can accomplish by
select * from targetdbf where exist(sele * from keywordsdbf where keywordsdbf.keyword=targetdbf.keyfield) into cursor query