"--CELKO--" <jcelko212@earthlink.net> wrote in message
news:d7d504b2-9f64-40d8-a76e-dc70051b514f@8g2000hse.googlegroups.com...
>>> A yes/no question does not have to derived / computed / etc. Do you
>>> like lemonade? Yes. Or no. Maybe your answer changes over time. But
>>> it does not depend on any other values whatsoever. <<
>
> But that preference is a value:
>
> CREATE TABLE Foobar
> (..
> beverage_choice VARCHAR(15) DEFAULT 'water' NOT NULL
> CHECK (beverage_choice IN ('lemonade', 'beer', etc.)),
>
> Surely, you would not ask "Do you live in Texas?" "Do you live in
> California?" etc. for all 54 states and territories? And don't forget
> a constirant to assure that only one of the 54 flags is set to 1.
>
> SELECT guest_name
> FROM Invitations
> WHERE beverage_choice = 'lemonade';
>
> Do you see the difference?

Yes, you went from the question, "Do you like FOO?" to "What is your choice
for dinner?"

Two completely different questions.

Nice try though.




--
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html