So you want to have 'n/a' as default if there is no measurement?. T-SQL has a COALESCE function which can be used to check whether the column is NULL and have a default value. Example:
COALESCE(table.columnName,"n/a") as anyName. if table.columnName is NULL, then n/a will be substituted. Hope this is what you are looking for. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:328839 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
