working fine. many thanks

thanks christopher !!

thats great work!!! but i need to use this query else where

and i dont want to create that table(tally ).

Is there any way around for doing this

thanks again Christopher Stobbs

its working and result is ---- hello what ru doing?

you have removed all the '/' but i need them and my expected result is

-- hello/what/ru/doing?/

thank you.

but its giving the below error

Invalid object name 'tally'.

sorry .

when i ran this query its giving me result as 'hello/'

and expected result is hello/what/ru/doing?/

http://www.mssqltips.com/tip.asp?tip=1180

this link may help you

think this may help you for scheduling an ssis package