Data Converted to BigInt contains Decimal with E Proceeding with Plus sign

See more:

SQL-Server-2005

SQL

SQL-Server

, +

i am using "SQL Server 2008 R2". I had a table that had a column Name TimeSpent varchar(250). I am storing some Positive integer values in it . I am using cast(TimeSpent as BigInt) To insert data into this table. Some data after insertion get converted into decimal proceeding with 'e+' some values. For example 1.27923e+006,1.30313e+006.

Please suggest me what datatype i use resolve this issue.