Ok, then it is a mystery because your original should work. Set CityStateZip = City + ' ' + State + ' ' + PostalCode
I will say this though, never duplicate data when it is not required. Because data duplication can grow a database fast. If it was me I would do something like this select City + ' ' + State + ' ' + PostalCode as CityStateZip Any time you require it. Once you get the syntax right of course.... -- Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/113032480415921517411 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:3488 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/sql/unsubscribe.cfm
