Update Wawa_DB Set CityStateZip = City + ' ' + State + ' ' + PostalCode Returns 19061.0
Putting quotes on the fields returns 0.0 -----Original Message----- From: Phillips, Dave [mailto:[email protected]] Sent: Monday, December 10, 2012 9:46 AM To: sql Subject: RE: Update data in a field from concatenated data Can you give us the actual statement that is doing this? I know you've had to change it a few times. Dave ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:3474 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/sql/unsubscribe.cfm
