Support 805.461.7300
Sales
Our Technology. Your Success.
Tech Notes

Find records that have more than one word in a field

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.

This related command can count the number of words in a field and populate a count field with that number.

« Back to Tech Notes

I’ve really enjoyed working with your company. Your customer service is the best and your product is as well!
T.M., Chapel Hill, NC