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: > > if i use like this, if any value is getting null value means all the value > is becoming null, how to avoid this > > > > > concatenate the 3 columns into one in your query. eg: > > > > SELECT address1 + ', ' + address2 + ', ' + address3 AS address > > FROM sometable > > > > > > > > Azadi Saryev > > Sabai-dee.com > > http://www.sabai-dee.com/ > > > > > > On 17/07/2009 17:42, RamaDevi Dobbala wrote: > > > Hi frnds, > > > > > > i need to pass address column to cfgrid column, but in my table i > > have 3 columns for that address(address,state,city), but while > > displaying i have to keep these three into the CFGRIDCOLUMN how to > > give that. > > > > > > > > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:324644 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
