lcText='red pencil' && or any string with a variable number of words lcWord=upper(getwordnum(lcText,1)) Select * from yourtable where lcWord$upper(yourfield) into cursor curdummy readwrite for x=2 to getwordnum(lcText) lcWord=upper(getwordnum(lcText,x)) Select * from curdummy where lcWord$upper(yourfield) into cursor curdummy readwrite endforNow you will have a cursor which contains all the records where ALL the words in lcText are present in yourfield. You may use this cursor as is if you don't need to be able to edit the table.
Index on PK tag PK && PK is primary key or an unique key Select 0 Use yourtable again Set relation to PK into curdummy Set filter to !eof('curdummy')>I need to filter in a list of products those contaning all words I type. Example: