Networks

Ask something
Question Locked

Change in Data

0 helpful
2 replies

by samitb70

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

2 replies

by tony hopkinson

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)

E.g
Select Convert(SomeType,SomeField,SomeFormat) From SomeTable

HtHs

This discussion is closed to new replies.