At 07:51 PM 12/15/01 -0500, you wrote: >----- Original Message ----- >From: "Anthony Abby" <[EMAIL PROTECTED]> >To: "CF-Talk" <[EMAIL PROTECTED]> >Sent: Friday, December 14, 2001 7:19 PM >Subject: Query Field with Null Value > > > > Silly question.... but what's the best way of building a query that will > > select records containing a specific WORD, AND also include records that >are > > NULL in the same field? > > > > (TC.Status <> 'Closed') OR (TC.Status = NULL) ????
Try: (TC.Status LIKE '%Closed%') OR (TC.Status IS NULL) Now available in a San Francisco Bay Area near you! http://www.blivit.org/mr_urc/index.cfm http://www.blivit.org/mr_urc/resume.cfm ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. 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
