Find records that have more than one word in a field

Technical information that doesn't fall into any of the other categories in this forum.

Moderators: Chrissy, Steve, Terry, Donna, Dave, Eric, MartyH, Kristen, Geoff, Vince

Post Reply
User avatar
Eric
Moderator
Posts: 1909
Joined: Tue Sep 19, 2006 3:29 pm
Contact:

Find records that have more than one word in a field

Post by Eric » Fri Dec 19, 2008 10:11 am

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.
Chat with an AccuZIP6 technician weekdays from 7-4 PST with AccuZIP6 Live Online Support

Post Reply