从sql server中的字符串中删除html标记的最佳方法是什么?

I've got data in SQL Server 2005 that contains html tags and I'd like to strip all that out, leaving just the text between the tags. Ideally also replacing things like I've got data in SQL Server 2005 that contains