>UPDATE #tempProfit > set profitDesc = stuff(cast(profitdesc as varchar(8000)), patindex('%Sell %' + rtrim(instrumentSymbol) + '%', profitdesc) + 4, > charindex(rtrim(instrumentSymbol) + ' @', profitdesc, patindex('%Sell %' + rtrim(instrumentSymbol) + '%', profitdesc) + 4) - > (patindex('%Sell %' + rtrim(instrumentSymbol) + '%', profitdesc) + 4), ' ') > >UPDATE #tempProfit > set profitDesc = stuff(cast(profitdesc as varchar(8000)), patindex('%Buy %' + rtrim(instrumentSymbol) + '%', profitdesc) + 4, > charindex(rtrim(instrumentSymbol) + ' @', profitdesc, patindex('%Buy %' + rtrim(instrumentSymbol) + '%', profitdesc) + 4) - > (patindex('%Buy %' + rtrim(instrumentSymbol) + '%', profitdesc) + 4), ' ') > > >>
>>set @cString = 'Buy @ test another test Sell @' >>set @FirstPosition = charindex('Buy ',@cString) + LEN('Buy ') >>set @LastPosition = charindex('Sell ', @cString) >> >>set @cNewString = replace(@cString, substring(@cString, @FirstPosition, @LastPosition - @FirstPosition),'') >>>>Something like this, not tested.