As part of the Advanced Wiki Search tool I wrote there is a VFP class that converts search expressions with operators AND, OR, NOT and ( ) into individual queries for each word and then uses SQLs to combine the individual results using the operators to get the final result. The article and code can be found at http://fox.wikis.com/wc.dll?Wiki~WikiAdvancedSearch