I have a question regarding null values. I have a data table, and that table has a few fields, some have data, some don't. What I'm trying to do is a cfif statement in a cfm page that if the databae query returns nothing for this specific field, then I want the web page to look a certain way, but if the query returned a value of 0 or greater, than I want the web page to look like something else. I thought I could do <cfif #CUMULATIVE_OM# IS NULL> but that doesn't work.....and if I put 0 in there instead of NULL, that doesn't work either, because there is nothing in the specific field. Any help would be greatly appreciated!!!