Can you give us the actual statement that is doing this? I know you've had to change it a few times.
Dave -----Original Message----- From: Denise Zuverink [mailto:[email protected]] Sent: Monday, December 10, 2012 9:33 AM To: sql Subject: RE: Update data in a field from concatenated data Actually I just changed the PostalCode field to a different text field just to see what it returned. No matter how I set it up it is only returns the last part of the query as well as always being returned in decimal format. Sounds like your column type on CityStateZip is set to decimal. If you are storing zip+4 as 99999-9999 then you need it set to either varchar(10) or char(10). If you are storing zip+4 as 999999999 then you could set it to integer. But in any case, you won't want it to be decimal. Dave Phillips ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:3473 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/sql/unsubscribe.cfm
