Page 1 of 1

Find records that have more than one word in a field

Posted: Fri Dec 19, 2008 10:11 am
by Eric
If you want to find the records in your database that have two words in a field, pull down the Select menu to Search Editor and use this search:

Field: LAST
Condition: CUSTOM COMMAND FILTER
Look For: WORDS(last)=2

Running that search will show you all records that have two words in the field called Last.