Alternate SQL Row-Selection Criteria, Take 3
January 11, 2006 Ted Holt
|
Two previous issues of this newsletter have presented ways to put two or more record-selection alternatives into one SQL query. I use these techniques often because they reduce or eliminate the need to clone programs. I recently learned another way to implement alternate record-selection criteria and would like to share it with you today. Let’s begin with an example table of people. create table mylib/people
( FirstName char(12),
LastName char(12),
Street char(20),
City char(16))
Here’s the data I placed into my copy of the PEOPLE table. FIRSTNAME LASTNAME STREET CITY ========= =========== ================= ============ Smith Whiteside 451 Elom Street Lost |
