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]))
**********