All column types are 'text' ?? is that the actual column type? Are you using SQL Server? If not, what database?
-----Original Message----- From: Denise Zuverink [mailto:dzuver...@print-art.net] Sent: Monday, December 10, 2012 10:27 AM To: sql Subject: RE: Update data in a field from concatenated data OK, I will keep trying. Something so simple seems to be making me insane because I can't work it out. I do appreciate all that you have helped me with. Thanks Denise ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:3491 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/sql/unsubscribe.cfm