*ahem* he? Damn, who told me about the sex change? I really wish people would keep me up to date on this stuff. ----- Original Message ----- From: "Jesse Houwing" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, September 18, 2002 12:07 PM Subject: Re: Returning columns with null values when specific columns are unknown at runtime
> Candace Cottrell wrote: > > 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 > > I think he wants the names of the colums that have null values as a > result. Though I have no idea how to do that, or what he would like to > use it for > > Jesse > > > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com 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