----- 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) ???? > > Thanks > Anthony > > > _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists