The solutions are really nice, but I just want to add something to the mix. This is a simple approach, but should be handled with care (with great power comes...

That one is repeated in multiple places...

Great! I'll have to learn something new today.

Lengthy, but there might not be a better alternative without fixing the data.

CREATE TABLE SampleData(
  col1 varchar(10),
  col2 varchar(10),
  col3 int
);
INSERT...

What do you mean by...

And here's a small improvement.

DECLARE @Number as int = 0
DECLARE @varnumber as varchar(2)

WHILE @Number < = 79
BEGIN
SET @Number = @Number...