Hints When Searching

Certain columns of this database have been defined as searchable. This is a 'smart search' - you do not need to provide the entire value. For instance, if you are searching for a name and you want 'John Smith', you need only provide part of the name like 'John'. This will give you a list of all records with 'John' in that field. Sometimes this might generate too many records, but often this will be enough.

This is actually a fairly sophisticated search, but you need to know some of the 'tricks'. Certain characters are 'wildcards' - they really stand for one or more characters. Some examples are probably all you really need.

More technical people will recognize these as SQL wildcards and they are correct. However, this application does not support ALL wildcard uses, just what has been shown here. Whatever you enter has the wildcard '%' prefixed and postfixed to the search string. Our goal here is to quickly get a reasonable set of possibilities for you to choose from - not to provide a generic query capability.