Re: Weird Query

well, sometimes there is a really really good reason to treat them differently, for instance:

Search criteria entered into a screen form: First Name: 'John'
Middle Name: 'Randall'
Last Name: 'Smith'

a row in the database
First Name: 'John'
Middle Name: unknown, however you choose to store the fact Last Name: 'Smith'
this is a possible match

another row in the database
First Name: 'John'
Middle Name: a known fact: no middle name, however you choose to store the fact
Last Name: 'Smith'
this is NOT a match

there are quite a few real life situations when we do need to treat them differently.
What do you think? Received on Mon Aug 01 2005 - 13:36:09 CDT