Having a brain cramp.
I have a table consisting of:
person_id - char(10)
flag_1 - logical
flag_2 - logical
flag_3 - logical
I want to do a SQL statment which returns the person_id for any person who has more than 1 of any of the flag fields set to TRUE.
select person_id from mytable where flag_1 OR flag_2 OR flag_3 ...but more than one of them....!
any ideas? Thanks - Larry
-- Larry Keyes
Remember only You can prevent Gray Goo. Never release nanobot assembers without replication limiting code.