in Cf 9 you can do IsNull()

> says ben nadel http://www.bennadel.com/blog/1654-Learning-ColdFusion-9-IsNull-And-Working-With-NULL-Values.htm
but from a query you can't.