title: How do I remove html tags in one of the column upon SELECT in sql server 2008?
body: <p>I have created a view of a data table, but there is an issue which is there are html tags in the string of one of my columns (column7). <strong>How can I remove all the tags and select only the text upon SELECT?</strong></p>
  
  <p>The below is the similar sample code for my views:</p>
  
  <pre><code>SELECT  /*+ FIRST_ROWS */ DISTINCT 
      [column1],
      [column2],
      [column3],
      [column4],
      [column5],
      [column6],
      [column7],
      [column8],
      [column9]
      FROM SAMPLETABLE
  </code></pre>