Any strings or text must be wrapped in quotes, so if your database column is not a ntext or text or varchar column then that will convert the data to numeric.
-- Regards, Andrew Scott WebSite: http://www.andyscott.id.au/ Google+: http://plus.google.com/113032480415921517411 On Tue, Dec 11, 2012 at 1:12 AM, Denise Zuverink <[email protected]>wrote: > > 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:3471 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/sql/unsubscribe.cfm
