select *,Area_Mgr_RDO as Director,Area_Note as dire_Note, IsNull(address,'') +IsNull(address2,'') + IsNull(address3,'') + IsNull(city,'') + IsNull(state,'') + IsNull(zip,'') +IsNull(country,'') as office_address from sourcebook_1
i am writings like this, but still it is giving the error >You would want to wrap each column in the query in an IsNull(coulmnName,'') > >Dave > >On Fri, Jul 17, 2009 at 8:46 AM, RamaDevi Dobbala <[email protected]>wrote: > >> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:324646 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
