Home Forums SQL Server 2008 T-SQL (SS2K8) how to remove leading 1 and zeros RE: how to remove leading 1 and zeros
Ben Teraberry
SSChampion
Points: 11845
More actions
August 27, 2016 at 11:13 pm
#1897976
Or if the issue is that some system's incremental numbers started at 1 trillion plus 1, you could just subtract 1 trillion from the BIGINT form of your number 😀
└> bt