Without know the type of column the PostalCode is it is difficult to say what is happening. You may need to CAST or CONVERT the PostalCode to a string to get the desired results.
Ray Thompson Tau Beta Pi Headquarters 865-546-4578 www.tbp.org Hardware eventually fails. Software eventually works. Well, software does not always eventually work. -----Original Message----- From: Denise Zuverink [mailto:dzuver...@print-art.net] Sent: Monday, December 10, 2012 9:13 AM To: sql Subject: RE: Update data in a field from concatenated data Thanks, I tried that and it is returning only the first five characters of the PostalCode and then a decimal and then 0 (19076.0). Although this is not what I want I have gotten somewhere and now that I have an idea I will mess around with a bit more. Thank you 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:3469 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/sql/unsubscribe.cfm
