CHAPTER 11 LISTS OF SIMILAR PERSONS, FAMILIES AND NOTES OR

SEARCHING YOUR FOLDER FOR SPECIFIC INFORMATION

PART C: OPERATORS USED IN WHERE COMMANDS...

In this section we assume that you know what a WHERE command is, how it's used, and what it's used for. We also assume that you know what an operator in a WHERE command is. If you haven't done so already, review the first section in this chapter, which is entitled "An Introduction with Basic Examples".

The WHERE command provides for a number of operators. We'll list them first, and explain each of them in turn afterward:

Operators for Numbers:

  1. Less Than
  2. Less Than or Equal To
  3. Equal To
  4. Not Equal To
  5. Greater Than
  6. Greater Than or Equal To

Operators for Dates:

(Note that the operators for strings, below, also apply to dates, but when those operators are applied, GIM LISTS treats the date as a string of characters rather than as a point in time.)
  1. Before
  2. On or Before
  3. On
  4. After
  5. On or After

Operators for Strings:

  1. Equal To
  2. Not Equal To
  3. Starts With
  4. Contains
  5. Ends With
  6. Is Missing
  7. Is Acceptable
  8. Is Complete

Operators for Notes:

  1. Contains
  2. Is Missing

Operators for Special Situations:

  1. Colon (:)

A Note About Operators:

All of the operators described in this section can be negated by prefixing them with any of the following:

In other words, for every positive operator, there is a corresponding negative operator.

For example ...

"CONTAINS" becomes "DOESN'T CONTAIN", "IS EQUAL TO" becomes "IS NOT EQUAL TO", "IS ON OR BEFORE" becomes "IS NOT ON OR BEFORE",

... and so on.

This means that you can come up with some pretty odd sounding negative operators -- "DOES NOT LESS THAN OR EQUAL TO" is a legal operator, but is more simply stated "IS GREATER THAN" -- but it also gives you the power to say whatever you want to say.

Operators for Numbers:

1. Less Than Synonyms:

Example: WHERE children LT 5
This WHERE command selects persons or families who have fewer than five children.

2. Less Than or Equal To Synonyms:

Example: WHERE children LE 5
This WHERE command selects persons or families who have at most five children.

3. Equal To Synonyms:

Example: WHERE children EQ 5
This WHERE command selects persons or families who have exactly five children.

4. Not Equal To Synonyms:

Example: WHERE children NE 5
This WHERE command selects persons or families who have any number of children but five.

5. Greater Than Synonyms:

Example: WHERE children GT 5
This WHERE command selects persons or families who have more than five children.

6. Greater Than or Equal To Synonyms:

Example: WHERE children GE 5
This WHERE command selects persons or families who have at least five children.

Operators for Dates:

1. Before Synonyms:

Example: WHERE birth date is before "4 Jul 1776"
This WHERE command selects persons who where born before 4 Jul 1776. Those born ON 4 Jul 1776 are NOT selected.

2. On or Before Synonyms:

Example: WHERE birth date is on or before "4 Jul 1776"
This WHERE command selects persons who where born on or before 4 Jul 1776. Those born ON 4 Jul 1776 ARE selected.

3. On Synonyms:

Example: WHERE birth date is on "4 Jul 1776"
This WHERE command selects persons who where born on 4 Jul 1776, and excludes all others.
Note that the opposite of "IS ON" is "IS NOT ON" and variations; this would select only those persons NOT born on 4 Jul 1776, which is rarely very useful, but it's possible anyway.

4. After Synonyms:

Example: WHERE birth date is after "4 Jul 1776"
This WHERE command selects persons who where born after 4 Jul 1776. Those born ON 4 Jul 1776 are NOT selected.

5. On or After Synonyms:

Example: WHERE birth date is on or after "4 Jul 1776"
This WHERE command selects persons who where born on or after 4 Jul 1776. Those born ON 4 Jul 1776 ARE selected.

Operators for Strings:

1. Equal To Synonyms:

Example: WHERE birth date EQ "30 Apr 1964"
This WHERE command selects persons whose birth date is "30 Apr 1964".
Note that persons whose birth date is "30 April 1964" will NOT be selected. (See IS ON under Operators for Dates, above.)

Example: WHERE birth place EQ "Poland"
This WHERE command selects persons whose birth place is "Poland".
Note that persons whose birth place contains "Poland", but is not identical to "Poland", such as "Posen, Poland", will NOT be selected. (See CONTAINS, below.)

2. Not Equal To Synonyms:

Example: WHERE birth place NE "Italy"
This WHERE command selects persons whose birth place is NOT "Italy".
Note that persons whose birth place is "Rome, Italy" WILL be selected. (See CONTAINS, below.)

3. Starts With Synonyms:

Example: WHERE surname STARTS WITH "Mad"
This WHERE command selects persons whose surnames start with "Mad", including "Madsen", "Madison", "Maddox", etc.
Note that DOESN'T START WITH is a valid operator, and represents the opposite of STARTS WITH.

4. Contains Synonyms:

Example: WHERE birth place CONTAINS "York"
This WHERE command selects any person whose birth place contains the word "York".
Note that all of the following birth places will be selected: Rye, Westchester, New York Halifax, Yorkshire, England York Township, Ontario, Canada
Note that the following birth places will NOT be selected UNLESS case sensitivity is OFF. (See the section entitled "A Glossary of GIM LISTS Commands with Examples", under the heading CASESENS, for details.) yorkshire, england NEW YORK CITY Note that the following birth place will NEVER be selected: Cambridge, Washington, NY Note that DOESN'T CONTAIN is a valid operator, and represents the opposite of CONTAINS.

5. Ends With Synonyms:

Example: WHERE surname ENDS WITH "sen"
This WHERE command selects persons whose surnames start with "sen", including "Madsen", "Larsen", "Johansen", etc.
Note that DOESN'T END WITH is a valid operator, and represents the opposite of ENDS WITH.

6. Is Missing Synonyms:

Example: WHERE birth date is missing
This WHERE command selects persons whose birth date is empty. Any part of a person or family which is capable of containing a string, such as first names, last names, dates, places, the AFN and the REFN may be tested for being missing.
Note that ISN'T MISSING is a valid operator, and represents the opposite of IS MISSING.

7. Is Acceptable Synonyms:

The "IS ACCEPTABLE" operator only has meaning when applied to dates, and to LDS ordinance places (baptisms, endowments, and sealings).
Note that IS NOT ACCEPTABLE is a valid operator, and represents the opposite of IS ACCEPTABLE.
Example: WHERE birth date is acceptable
A date is "acceptable" if it occurred during or after the year 1000 AD. Strictly speaking, a date is acceptable if it contains a number greater than 1000. The concept of a date being "acceptable" should be thought of as being "better than nothing, but not necessarily complete".

Example: WHERE endowment place is acceptable
A place is "acceptable" if GIM LISTS can figure out which temple is intended by the place string; or if the place string contains the word "living", indicating a living LDS baptism. The following places are acceptable, but not complete:

The following places are not acceptable:

8. Is Complete Synonyms:

The "IS COMPLETE" operator only has meaning when applied to dates, and to LDS ordinance places (baptisms, endow- ments, and sealings).
Note that IS NOT COMPLETE is a valid operator, and represents the opposite of IS COMPLETE.
Example: WHERE birth date is complete
A date is "complete" if it is in the form "DD Month YYYY", such as "30 Apr 1964" or "4 July 1776". Note that "4 Jul 1776" and "4 July 1776" are both equally complete, as are "5 Sep 1939" and "5 Sept 1939". The concept of a date being "complete" should be thought of as "contains no ambiguities, such as question marks or other punctuation." In other words, the following dates are not complete (although they are all acceptable): 3 or 30 Apr 1964 before 1700 16 Jul 1962? 5,6 Aug 1894

Example: WHERE endowment place is complete
A place is "complete" if GIM LISTS can figure out which temple is intended by the place string, AND if that place string is the same place name that is contained in the GIMTPL.GIM file. A place name is also complete if the place string contains the word "living", indicating a living LDS baptism. The following places are complete:

Operators for Notes:

1. Contains Synonyms:

Example: WHERE birth source notes CONTAIN "microfilm"
This WHERE command selects persons whose birth source notes contain the word "microfilm" anywhere in the note. This operator functions similarly to the CONTAINS operator for strings.
Note that DOESN'T CONTAIN is a valid operator, and represents the opposite of CONTAINS.

2. Is Missing Synonyms:

Example: WHERE birth source notes IS MISSING
This WHERE command selects persons whose birth source notes are empty. This operator functions similarly to the IS MISSING operator for strings.
Note that ISN'T MISSING is a valid operator, and represents the opposite of IS MISSING.

Operators for Special Situations:

1. The Colon Operator Synonyms:

Example: WHERE any source note : contains "microfilm" and doesn't contain "census"
This WHERE command selects all persons or families where any note contains the word "microfilm" but doesn't contain the word "census".
PLEASE NOTE: The colon operator is considered an advanced -- rather than a basic -- feature of GIM LISTS, and it should only be attempted by those persons who feel comfortable with the basic features of GIM LISTS, and who have read and understood the section entitled "Advanced Examples; Arcane WHERE Command Syntax". See that section for more details.