This should done the job for you =) <cfif qQuery.field is "">
-----Original Message----- From: Thomas Chiverton [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 05, 2001 9:48 PM To: CF-Talk Subject: Checking for NULL How do I compare a field for a NULL value ? <cfif qQuery.field is NULL> ? Regards, Thomas Chiverton Intranet Architect 01565 757 909 The web is the borderless embodiment of every abstraction ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ 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