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 ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
