For SQLite, the concatenation operator is || according to this page: http://www.sqlite.org/lang_expr.html
So, if that's the case, what happens when you run this: Update wawa_db Set CityStateZip = City || ' ' || State || ' ' || PostalCode If that doesn't work, do this and see what the data looks like (and post a sampling): Select top 5 city,state,postalcode from wawa_db -----Original Message----- From: Denise Zuverink [mailto:dzuver...@print-art.net] Sent: Monday, December 10, 2012 10:42 AM To: sql Subject: RE: Update data in a field from concatenated data SQLite for now, we are in the process of converting to SQL Server but this is all I have to go with at the moment. -----Original Message----- From: Phillips, Dave [mailto:dave.phill...@verizonwireless.com] Sent: Monday, December 10, 2012 10:31 AM To: sql Subject: RE: Update data in a field from concatenated data 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:3496 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/sql/unsubscribe.cfm
