I am all good with the below Update wawa_db Set CityStateZip = (City || ' ' || State || ' ' || PostalCode)
Work perfectly -----Original Message----- From: George Gallen [mailto:[email protected]] Sent: Monday, December 10, 2012 1:53 PM To: sql Subject: RE: Update data in a field from concatenated data Are you getting any errors? What is the number of rows affected listed as? Do you have a where clause? that is not being shown? George I realize below is not the Original Poster, being directed to them. (if this is a dup, sorry, my original got kicked back for too man lines....this one is nicely trimmed!) > To: [email protected] > Subject: RE: Update data in a field from concatenated data > Date: Mon, 10 Dec 2012 10:05:22 -0600 > From: [email protected] > > > Another option: > > Update wawa_db > Set CityStateZip = ifNull(City,'') || ' ' || ifNull(State,'') || ' ' > || ifnull(PostalCode,'') > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3505 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/sql/unsubscribe.cfm
