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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
