Geeklog: What I Learnt Today / Adam

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'

/ Adam