InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 02:36:48 GMT20http://www.sqlservercentral.com/Forums/Topic632037-338-1.aspxPart of my point here is to turn the OP to the direction of tally tables also.I purposely have asked him to look at them.Here is a simple way to create a Tally Table (Shamelessly copied from Jeff's article).[quote]--=============================================================================-- Create and populate a Tally table--=============================================================================--===== Conditionally drop and create the table/Primary Key IF OBJECT_ID('dbo.Tally') IS NOT NULL DROP TABLE dbo.Tally CREATE TABLE dbo.Tally (N INT, CONSTRAINT PK_Tally_N PRIMARY KEY CLUSTERED (N))--===== Create and preset a loop counterDECLARE @Counter INT SET @Counter = 1--===== Populate the table using the loop and couner WHILE @Counter <= 11000 BEGIN INSERT INTO dbo.Tally (N) VALUES (@Counter) SET @Counter = @Counter + 1 END[/quote][url=http://www.sqlservercentral.com/articles/TSQL/62867/]http://www.sqlservercentral.com/articles/TSQL/62867/[/url]Wed, 07 Jan 2009 19:18:13 GMTvick.ram79http://www.sqlservercentral.com/Forums/Topic632037-338-1.aspxThanks nil...prob solved!!Wed, 07 Jan 2009 19:12:12 GMTSuperdechttp://www.sqlservercentral.com/Forums/Topic632037-338-1.aspxTry this one:Declare @str varchar(20),@i as intSet @str='HELLOW WORLD'Set @i=1While @i <= len(@str)Begin print left(@str,@i) Set @i=@i+1EndWed, 07 Jan 2009 19:09:13 GMTnil-364356http://www.sqlservercentral.com/Forums/Topic632037-338-1.aspxdeclare @str varchar(20)set @str = 'HELLO WORLD'select SUBSTRING(@str, 1,n)from Tally twhere N<=LEN(@str)The 'Tally' table is simple table of numbers.... pls look for articles on Tally table here...My Tally Table has only a single column called N.Wed, 07 Jan 2009 18:58:44 GMTvick.ram79http://www.sqlservercentral.com/Forums/Topic632037-338-1.aspxHow to PRINT below string pattern in T-SQL 2005:[b]Input:[/b]SET @str = 'HELLO WORLD'[b]Output:[/b]HHEHELHELLHELLOHELLO HELLO WHELLO WOHELLO WORHELLO WORLHWLLO WORLDThanks in advance.Wed, 07 Jan 2009 18:43:08 GMTSuperdec