Yes. I reloaded the table in 10g from the table in 9i. Both have mix of number values and char values. Subject: RE: data type conversion in 10gDate: Tue, 3 Jul 2007 14:07:44 -0400From: Thomas.Mercadante@xxxxxxxxxxxxxxxxxxx: davidb158@xxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx David, Did you review the data in the field from the two databases? Maybe the 9i database has all number values while the 10g database has some char values? Tom _________________________________________________________________ See what you’re getting into…before you go there. http://newlivehotmail.com