>but agreed that isnull() is more "readable" than both the CASE and >coalesce() suggestions :)
Yes, I'll grant you IsNull() does have the more descriptive (or intuitive) name. ISNULL(col,'YOURINDICATORFORNULL) AS col COALESCE(col,'YOURINDICATORFORNULL) AS col ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Enterprise web applications, build robust, secure scalable apps today - Try it now ColdFusion Today ColdFusion 8 beta - Build next generation apps Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:290583 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
