Eugene Elutin (7/29/2013)
Jeff Moden (7/29/2013)
Eugene Elutin (7/29/2013)
Solomon Rutzky (7/27/2013)
23847234872893475983479583749583749573945739 is all digits, is a valid number, but is NOT convertible to any SQL Server number types as it is larger than 38 digits ...
You can convert it to float (with lose of some precision ;-))
select cast('23847234872893475983479583749583749573945739' as float)
Considering that FLOAT only has 15 digits of precision, it'll be a pretty big loss. 🙂
I wouldn't call 1.32% a such "big loss" :hehe:
However you are right! It does depend! If this loss constitutes my interest in £ - I would probably die from heart-attack 😀
Heh... absolutely agreed but wasn't talking about the loss in "value" of the number. Was talking about the number of digits that would be lost when trying to determine if a long string could be checked for "IsAllDigits".
--Jeff Moden
Change is inevitable... Change for the better is not.