Assuming you know there is only one non-zero leading digit, doesn't matter how many zeroes there are
DECLARE @Number BIGINT;
SET @Number = 1000000017777;
SELECT CAST(RIGHT(@Number, LEN(@Number) - 1) AS INT);
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability