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'