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

i sql server 2005 ....on server machine

sql server 2008 on client machine...