Try this one:

Declare @str varchar(20),@i as int

Set @str='HELLOW WORLD'

Set @i=1

While @i <= len(@str)

Begin

print left(@str,@i)

Set @i=@i+1

End