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:3472 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/sql/unsubscribe.cfm
