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

Just wanted whoever receives this to know that AccuZIP6 has the best technical support people ever--in any industry. Without Exception they get my vote for #1.
P.D., Silver Spring, MD