Don't have enough to really go on, but this will get ou started. You can pick off the remaining end tag

declare @xml varchar(100)

set @xml = 'Featured in <a href="/back_to_school">Back to School</a>'

select @xml,

charindex('>',@xml)

,stuff(@xml,12,charindex('>',@xml)-11 ,' ')

Jim