Convert Exponential Number to Non Exponential Number TSQL 1

[JcTon]

Familiar with using the following to convert dates within Sql Query Analyzer;

convert(varchar,START_DT,110) SeriesStartDt

Question - How do I convert a exponential number to a non-exponential number?

Currently, when I run the query in SQL Query Analyzer and then import the results into Microsoft Access, there is data missing. Missing data includes numbers in exponential format and some date fields.

 

[gmmastros]

>>
Question - How do I convert a exponential number to a non-exponential number?

Convert to float. Ex:

Select Convert(float, '2e5')

-George

"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom