Hi Akhil,
You could refer this
link[
^], it will help you to remove the HTML tags from your string but you need customize more to get expected answer
If you want you can do it in C#, below is the code snippet you can make use of.
string htmlString = @"<P>This is a test Message</P> My salary is <$500 and i have to spent >Rs 899 <br/> Please suggest<font></Font>";
string outputString = string.Empty;
System.Text.RegularExpressions.Regex rx = new System.Text.RegularExpressions.Regex(@"<[^>]\S*>");
outputString = rx.Replace(htmlString, "");
String handling is always easy in C# when compared to SQL for most of them ;-)
So I recommend you to get the string from sql server and manipulate in C# (may be)
Hope this helps you a bit.
Regards,
RK