Yea, the field can be empty (contain '') but it can also be null, and '' will not match null.
You will need something like WHERE RAPSSubmitted IS NULL or WHERE RAPSSubmitted IS NOT NULL russ -----Original Message----- From: Claremont, Timothy [mailto:[EMAIL PROTECTED] Sent: Tuesday, March 01, 2005 4:31 PM To: CF-Talk Subject: Simple WHERE question Having a bad brain day today. I am querying a table to check the condition of two fields (RAPSSubmitted and RAPSRNS). I just need to know if the fields are blank or not. Actual content is irrelevent. I need four queries that catch each of the four possibilits (both populated, both empty, one populated, the other populated) What I have is this (for example): <cfquery name="GetRAPSSubmitted" datasource="Encounters"> Select * from tblEncounters WHERE RAPSSubmitted <> '' AND RAPSRNS = '' AND SelectMonth = '#SelectMonth#' AND SelectYear = '#SelectYear#' </cfquery> I have only listed one query for example sake. Bottom line, when I run all four queries, I do not come up with the total number of records in the database! Is there a fundamental problem with my technique of checking the four possibilites here? TIA, Tim ********************************************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please delete it from your system. This footnote also confirms that this email message has been swept for the presence of computer viruses. Thank You, Viahealth ********************************************************************** ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:197021 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
