Where do you want to strip the tags? If you have a query which returns some data to the front code, and would like to use some front end code to perform the cleaning then you can use a regular expression to do so. In this case, you will need an appropriate using statement (if you program in C#) using System.Text.RegularExpressions; // and then somewhere in you code Regex.Replace(input, @"
", " ").Trim() For example, string input = "
Welcome to our site
" + "Some text
"; string stripped = Regex.Replace(input, @"
", " ").Trim(); Console.WriteLine(stripped.ToString()); The code above prints **Welcome to our site Some text** after html tags are stripped. This pattern finds and strips 3 types of tags: opening tags, closing tags and self-closing tags which might have some spaces between the name of the tag and its self-closing part, such as in <br /> Oleg
Thank you Oleg and SirSQL for responding. I am not a programmer so don't clearly understand your replies. To clarify, I am using SQL to pull data via Query Analyzer then move it to Excel.....an example of the data: <html><body>Clarification is needed among Messaging, Billing, and Self Service teams regarding the handling of bounced email messages. Different teams may be making different assumptions.</body></html> Do you know of any SQL function that would accomplish this? Thank you.,Thank you Oleg and SirSQL for your replies. I am not a programmer so I don't clearly understand your responses. I am running a SQL statement in Query Analyzer to extract data then moving it into excel. One of the fields is a description field, which has these tags as shown below. I was hoping for a way to suppress them in my sql stmt. <html><body>Clarification is needed among Messaging, Billing, and Self Service teams regarding the handling of bounced email messages. Different teams may be making different assumptions.</body></html>