« Filters, Groups & SQL Queries | Main | What's Old Is New Again »

Wild Card Searching

Wild card searching is allowing some mix of characters, any characters, to occur within the field you are searching. 

For example, you are searching for 'City of Midland' in your database as a company name, what if it was entered "Midland, City Of" or just "Midland".  Or, if you are searching by Additional Contacts, and you don't remember the person's first name so you want to search by last name.  It'd be nice to just type Midland and any contact with Midland anywhere in the company name would show up.

If you are using GoldMine 4.0, 5.x, or 6.x with a Microsoft SQL Server database (Corporate Edition) or 7.0 with either the Microsoft SQL or FireBird database you can!

Simply type a '%' (without the quotes) before the string of character you are searching for.  Here's an example from the Contact Search Center.

Wildcard

Post a comment

(If you haven't left a comment here before, you may need to be approved by the site owner before your comment will appear. Until then, it won't appear on the entry. Thanks for waiting.)

About

This page contains a single entry from the blog posted on October 11, 2006 9:45 PM.

The previous post in this blog was Filters, Groups & SQL Queries.

The next post in this blog is What's Old Is New Again.

Many more can be found on the main index page or by looking through the archives.

Powered by
Movable Type 3.34