AK wrote:
>>>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?
The only solution is to have a single character string with
values such as Y(es) or N(o) to indicate how the business
rule is to be applied to the row.
--
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Mon Aug 01 2005 - 19:03:18 CDT
