How about this.... or am I still missing something Select * from TABLENAME WHERE col1 IS NULL OR col2 IS NULL OR col3 IS NULL OR col4 IS NULL
Candace K. Cottrell, Web Developer The Children's Medical Center One Children's Plaza Dayton, OH 45404 937-641-4293 http://www.childrensdayton.org [EMAIL PROTECTED] >>> [EMAIL PROTECTED] 9/18/2002 11:17:41 AM >>> Thanks, but that doesn't get me where I want. I ONLY want to return the columns that ARE null, and I never know which ones those are when I run this query... so what I need is something for the select statement. -Patti ----- Original Message ----- > The only thing I can think to do is create a bunch of OR statements i.e.: > WHERE colA IS NULL OR colB IS NULL OR colN IS NULL > > ~Simon > > > -----Original Message----- > > > Is there a way to write a MSSQL 2k query that will return a result set that > contains only columns with null values when you don't know explicitly which > columns those will be? > > So if I have this data > > pk | col 1 | col 2 | col 3 | col 4| > 1 1 2 null null > 2 null 4 null null > > I'd like a query that would return col 3 and col 4 where pk = 1 or col 1, > col 3 and col 4 where pk=2. > > Is this possible? > -Patti ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists