Change in Data

By samitb70 ·
I have transerred data from excel to a table created in SQL Server.
The problem is the data which was transferred in a column having numeric data type shows the data in exponential form when data retrieved using select statement.
Pls. Help

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

A couple of things you can do there

by Tony Hopkinson In reply to Change in Data

You can use an alter table statement and convert the column to another type
decimal, int etc ( try not to use float)

The other is to use the convert function

which converts between types and allows formatting ( abit like setting the format in a cell)

Select Convert(SomeType,SomeField,SomeFormat) From SomeTable


Related Discussions

Related Forums