Cfquery returns null in query result as [empty string] when you cf dump it

> So if you want to tell if something is null or what cf query cfdumps as [empty string] you can do this asc(field) Eq '0' when field is your db field to tell if is null or as craig says len(field) Eq '0'