Denise, Your original query did not have the SET statement in it, even though you were using the correct concatenate operator. Try the query exactly as Dave suggested. Let us know the result of that.
-Carl V. On 12/10/2012 8:00 AM, Denise Zuverink wrote: > Yes that is what my code originally started with and that returned a query > with the data exactly like I needed it but I could not get the update command > to update the database. > > > -----Original Message----- > From: Phillips, Dave [mailto:[email protected]] > Sent: Monday, December 10, 2012 10:58 AM > To: sql > Subject: RE: Update data in a field from concatenated data > > > 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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:3500 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/sql/unsubscribe.cfm
