TMG-L ArchivesArchiver > TMG > 2010-10 > 1287944371
From: "Michael J. Hannah" <>
Subject: Re: [TMG] Wish list
Date: Sun, 24 Oct 2010 12:19:31 -0600
On 10/24/2010 David Ball asked:
> ... it would be nice to have wild cards ...
> so I can find couples with variant spellings
> and a range of birth years
TMG already has search operators for this. For names, (see TMG Help
topics "Picklist Filter", "Filter the Project Explorer") you can use the
Windows standard wildcard characters of '*' and '?' for variant
spellings when you use the "LIKE" operator. [There have been some
reported cases where this does not seem to work and have been reported
as bugs, but try it anyway.]
? - The ? will match any one character.
For example, H?T will match "hat" or "hot" or "hut".
* - The * will match any string of characters.
For example, MER* will match Merry, Merriment, Merrimac, etc.
There is the operator "Is between" where you can give two character
values separated by a comma; for example, "GivenName Is Between A,C" or
"Surname Is Between SA,SE"
You can even use operators such as <> (not equal), >= (greater than or
equal to), <= (less than or equal to), > (greater than), and < (less
than) when searching for names. (See the TMG Help topic "Search the
Project Explorer") For example, let's say you would like to look at
every person in a data set or project whose name is Eliza. But you don't
want to have to sift through all the Elizabeths too. You can't say
GivenName = Eliza because that would miss all of the Elizas who have a
middle name or initial. You can't say GivenName Contains Eliza because
that would also give you the Elizabeths. But you can set search criteria
GivenName >= Eliza
GivenName < Elizabeth
Range operators are also available for birth years. For examples see
the TMG Help topic "Filter and Accent Examples".