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 can't believe how excellent your support is. The last disaster you rescued me from was one that a programmer had told me had no answer that he knew of. Well, you know more than him! I e mail ed you on a SATURDAY and you had the problem solved by Monday morning!
C.P., Houston, TX