declare @string varchar(max) = '25475675675675675675675675675587876865674553334645647656786867879789780890890789676565674545634343453445675756756786867897978978078997896785657454563445345234534645675678768997807867567456342323167567567567567567567567567567567567567567567665756756756756756756756756756756756756756767876879789797287686782567345345289789797278978978978979245645622222245645622222222435645645645646364564564564564564564564564564564564564564564564562'

declare @s-2 varchar(1)

declare @totalcount int = 0

declare @count int

set @count = LEN(@string)

while (@count != 0)

begin

set @count = @count - 1

set @s-2=convert(int,left(@string, 1))

set @string = RIGHT(@string, len(@string)-1)

set @totalcount = @totalcount + @s-2

end

print convert(varchar,@totalcount)

Thanks,

Sumit Rastogi