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

We love the database and how simple it is for us to make simple codes as our business always has since 1955...We are grateful to you and your staff that take client service so seriously.
K.W., Hobe Sound, FL