Declare @myTable table (col1 varchar(100), processed varchar(100), results int)

Insert Into @myTable values ('186475',null,0)
Insert Into @myTable values ('54224793',null,0)
Insert Into @myTable values ('35512347',null,0)
Insert Into @myTable values ('124',null,0)
Insert Into @myTable values ('722185',null,0)
Insert Into @myTable values ('3351118',null,0)

Select * From @myTable

While exists(Select 1 From @myTable Where len(Col1)>0)
Begin
	Update @myTable
	Set 
		col1 = Right(col1,len(col1)-1),
		processed = isnull(processed,'') + left(col1,1),
		results = results + convert(int,left(col1,1))
	From @myTable
	Where len(Col1)>0
End

Select * From @myTable

quote:

---

How can I add all the digits in the column

---

create table numbers ( n int primary key)
declare @n int
set @n = 0
while @n <=1000
begin
	insert into numbers
	select @n
	set @n = @n+1
end

    
select custid, sum(convert(int,substring(custid,n,1))) sum_custid
from checkdigit c, numbers n
where n <= len(custid)
and n > 0
group by custid