CemToPictureBOOK

Help - SQL RECORD SELECTION

If an exact copy of the database is to be created: click on Select ALL and read no farther.

This area may seem difficult at first glance, but the examples should help. The program has been designed with a powerful feature to allow the users of the software to select records based on their own criteria.

EXAMPLE-1: Select all last names of Jones and Smith

• ENTER
• lastname="jones" OR lastname="smith"

EXAMPLE-2: Select all monuments with last names beginning with Ka and Sm

• ENTER (Use an asterisk *)
• lastname="ka*" OR lastname="sm*"

EXAMPLE-3: Select all monuments in a Church Cemetery

• ENTER (Use an asterisk *)
• cemetery="church cemetery*"

EXAMPLE-4: Select all monuments with last names beginning with Smith in Church Cemetery

• ENTER (Use an asterisk *)
• lastname="smith" AND cemetery="church cemetery*"