>>>lcTextToFind='mouse trap living toom' >>>lcWord=GetWordNum(lcTextToFind,1) >>>Select * from yourtable where lcWord$yourfield into cursor curdummy readwrite >>>if _tally>0 and GetWordCount(lcTextToFind)>1 >>> For lnX=2 to GetWordCount(lcTextToFind) >>> lcWord=GetWordNum(lcTextToFind,lnX) >>> Select * from curDummy where lcWord$yourfield into cursor curdummy readwrite >>> EndFor >>>EndIf>>>
Create cursor WordsToSearch(Word C(50)) insert into WordsToSearch values ('Word1') insert into WordsToSearch values ('Another Word') insert into WordsToSearch values ('Yet another') lnI = 0 scan lnI = lnI + 1 lcWord = ' ' + WordsToSearch.Word + ' ' if lnI = 1 select * from myTable where ' ' + myFieldToSearch + ' ' LIKE '%' + lcWord + '%' into cursor OurTempResult nofilter else select * from OurTempResult where ' ' + myFieldToSearch + ' ' LIKE '%' + lcWord + '%' into cursor OurTempResult nofilter endif ** Or alternatively select * from myTable where lcWord $ ' ' + myFieldToSearch + ' ' endscanvs. one Select solution. (this is from the top of my head - your idea of searching for each word in a loop)