Re: Weird Query

>>You know, the '' is equivalent to NULL.
<<

I have some reservations, such as:

situation A:
First Name: 'John'
Middle Name: '' (unknown, not a required field) Last Name: 'Smith'

situation B:
First Name: 'Igor'
Middle Name: '' (a known fact: no middle name at all. Russians do not have middle names. Patronymic names are not middle names) Last Name: 'Petrov'

how would you distinguish between situations A and B? Received on Mon Aug 01 2005 - 12:53:07 CDT