Re: FW: [SQL] Case Statement

2002-07-31 Thread Stephan Szabo
On Wed, 31 Jul 2002, Tom Haddon wrote: > Hi Stephan, > > I have a lot of fields, so I'm not sure if a function or case is the way to > go. Basically, I have, say 50 boolean fields that are being evaluated, and I > want to have a column which is the sum of the number of "TRUE" values of > those 5

FW: [SQL] Case Statement

2002-07-31 Thread Tom Haddon
Hi Stephan, I have a lot of fields, so I'm not sure if a function or case is the way to go. Basically, I have, say 50 boolean fields that are being evaluated, and I want to have a column which is the sum of the number of "TRUE" values of those 50 columns, and then ORDER BY that column. So, for ex