CODEWITHSUNDEEP
sqlsql-serverbankid
B.Doe12
B.Doe12

Reputation: 23

Storing KID number avoiding scientific notation

When I try to store KID numbers in SQL server I end up with scientific notation (6.9xxxxE+18). They are now stored in a FLOAT datatype. While I understand that this saves space, It really doesn't do much for the readability. I want them to be the following: 69xxxxxxxxxxxxxxxxx (numbers instead of x).

I've tried the following:

convert(bigint, [kid])
Arithmetic overflow error converting expression to data type bigint.

convert(varchar, [kid])
6.9xxxxE+18


str(convert(varchar, [kid]))
**********

Upvotes: 0

Views: 58

Answers (0)

Related Questions