Home Forums SQL Server 2005 T-SQL (SS2K5) T-SQL 2005 String Pattern?? RE: T-SQL 2005 String Pattern??
nil-364356
SSC Veteran
Points: 290
More actions
January 7, 2009 at 7:09 pm
#923037
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