DECLARE @str varchar(16), @i int SET @str = 'DEMO' SET @i = 1 WHILE (@i <= DATALENGTH(@str)) BEGIN PRINT SUBSTRING(@str, @i,1) SET @i = @i + 1 END