If these are in fact logical values, ie 0 or 1, then you could try something like:
SELECT pa_ab, pa_sk, pa_mb, pa_on, pa_nb, pa_pei, pa_ns, pa_nf, pa_bc, pa_bc, pa_pq, pa_yk, pa_nwt, pa_nu FROM USERS WHERE (pa_ab + pa_sk + pa_mb + pa_on + pa_nb + pa_pei + pa_ns + pa_nf + pa_bc + pa_bc + pa_pq + pa_yk + pa_nwt + pa_nu >= 1) not sure how effecient such a query would be though.... Jillian Carroll wrote: > > I have this query (that doesn't work): > > <cfquery name="provadmin" datasource="#DSN#"> > SELECT pa_ab, pa_sk, pa_mb, pa_on, pa_nb, pa_pei, pa_ns, pa_nf, pa_bc, > pa_bc, pa_pq, pa_yk, pa_nwt, pa_nu > FROM USERS > WHERE pa_ab=1 OR pa_sk=1 OR pa_mb=1 OR pa_on=1 OR pa_nb=1 OR pa_pei=1 OR > pa_ns=1 OR pa_nf=1 OR pa_bc=1 OR pa_bc=1 OR pa_pq=1 OR pa_yk=1 OR pa_nwt=1 > OR pa_nu=1 > </cfquery> > > How can I specify: Where 'any' of these fields equals 1? > > -- > Jillian > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
