>>I need to filter in a list of products those contaning all words I type. Example:
>>
>>If I type "red pencils" and my list is:
>>
>>1-This are red pencils
>>2-Somes pencils are red
>>3- I need a pencil
>>
>>Only 1 and 2 satisfy the filter. Any easy way to do this with SET FILTER TO?
>
>set filter to " " + myField + " " LIKE '% ' + myFirstWord + ' %' and ;
>" " + myField + " " LIKE '% ' + mySecondWord + ' %'
I think the like % syntax only works in sql. You have to use the like() function
Gregory