thanks greg

thanks a lot Gsquared..i appreciate it

thanks a lot

This seems to be a cool way with just one select statement.I really like this forum and you guys are making this lively.myself vijay ,i am like a fresher trying...

Hey parackson.

thanks a lot for your prompt and awesome reply.it exactly answered my query.i also figured out a way to do it something similar to yours just now.i am sharing...

thats another cool way by sscommitted....thank you....

Hey guys thanks a lot for all your help.......i appreciate the same...

i found another way of doing it .

here is the code.

DECLARE @LEN INT,@chOneLetter char(10),@string varchar(50),@initial int,@counter int,@Finalans varchar(50) ...