Conversion of Exponential to Decimal

rsbn1985 · Post by **rsbn1985** » Wed Dec 02, 2009 11:18 pm

I have data that contains both exponential and decimal numbers. So can someone please suggest how i can differentiate between exponential and decimal data and help me in conversion of exponential data to decimal...

gssr · Post by **gssr** » Thu Dec 03, 2009 12:08 am

What is the data type of the data.......

rsbn1985 · Post by **rsbn1985** » Thu Dec 03, 2009 12:25 am

Its varchar

gssr · Post by **gssr** » Thu Dec 03, 2009 12:46 am

Convert the Varchar Column to Decimal Datatype and Use maximum default length and Scale value

rsbn1985 · Post by **rsbn1985** » Thu Dec 03, 2009 1:29 am

But how do i differentiate between a decimal and exponential number

ray.wurlod · Post by **ray.wurlod** » Thu Dec 03, 2009 2:08 am

Why would you want to?

chulett · Post by **chulett** » Thu Dec 03, 2009 7:58 am

I'm assuming what Ray means is you shouldn't have to. Try the conversion noted and let us know what happens.