>>Hi, i am getting data out of a database. i need to be able to check if a value returned in a query is null.
If the idea is just because you want to ignore null values, better simply set a condition in the query, ie: WHERE myColumn NOT IS NULL If what you want is being able to distinguish nulls from empty strings, here is a way that is universal in any SQL flavour: SELECT "no" AS isNull, myColumn, otherColumns WHERE myColumn NOT IS NULL UNION SELECT "yes" AS isNull, myColumn, otherColumns WHERE myColumn IS NULL ORDER BY whatever -- _______________________________________ REUSE CODE! Use custom tags; See http://www.contentbox.com/claude/customtags/tagstore.cfm (Please send any spam to this address: [EMAIL PROTECTED]) Thanks. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:290655 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4