title: Is it possible to change &amp; to & in the results from a LINQ query?
body: <p>I have the following code:</p>
  <pre><code>Dim db As New linqclassesDataContext
  Dim categories = (From c In db.faq_cats)
  NewFaqDropDownCategory.DataSource = categories
  NewFaqDropDownCategory.DataTextField = &quot;category&quot;
  NewFaqDropDownCategory.DataValueField = &quot;category_id&quot;
  If Not Page.IsPostBack Then
      NewFaqDropDownCategory.DataBind()
  End If
  Unset(categories)
  Unset(db)
  </code></pre>
  <p>One of the items under the column &quot;category&quot; has <code>&amp;amp;</code> in the title, and that shows up in the dropdownlist as such.  Is there someway to make the list display &quot;&amp;&quot; instead?</p>
  <h3>One Solution</h3>
  <p>I figured I could use the .Replace() function to do this, and I accidentally found out how:</p>
  <pre><code>For Each c In categories
      If c.category.Contains(&quot;&amp;amp;&quot;) Then
          c.category = c.category.Replace(&quot;&amp;amp;&quot;, &quot;&amp;&quot;)
      End If  
  Next
  </code></pre>
  <p>I could expand this in the future to process other values as well.</p>