i am begginer and knowlede of cross apply , if it can be done by cte it is more helpfuly for me to understand and modify as per...

CREATE TABLE TBL_INTRATE

( SCHEMEID NUMERIC(10),...

thanks to all , now i do it my way can you please help to shorten this code

declare@strvarchar(20)= '[p]a]a]s]s][p'

declare@posint

select@pos= charindex('[', @str)

while@pos<> 0

begin

select@str = stuff(@str, @pos + 1,...

i sql server 2005 ....on server machine

sql server 2008 on client machine...