• 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