Hi,

What do you mean OP function???

Great.....Super modification...Thanks for your input........

Thanks for your valuable input.....

Great....Thanks for giving the nice input.....

hi,

pls use this altered function , which will give you the desired result.

alter function fn_split_btw_patterns(@inputstring varchar(max),@firstpattern varchar(max),@secondpattern varchar(max))

returns varchar(max)

as

begin

declare @returnstring varchar(max)=''

declare @start int

declare @end int

select @start = patindex('%' +...