I am having a mental block and was hoping someonce could help me. I am trying to update data in a feild from concatenated data. This is the code I wrote and it is a returning a query exactly like I want to see it in the feild but replace/update just does not seem to be working.
SELECT Wawa_DB.city || ' ' ||Wawa_DB.state || ' '|| Wawa_DB.postalcode FROM Wawa_DB I am using Navicat ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:3460 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/sql/unsubscribe.cfm
