title: How to make grid results show "<" rather than "&lt;"?
body: <p>This code:</p>
  
  <pre><code>SomeField + ' &lt;' + cast(count(AnotherField) as varchar(6)) + '&gt;'
  </code></pre>
  
  <p>Generates the following result in the grid view:</p>
  
  <pre><code>Blah &amp;lt;Blah2&amp;gt;
  </code></pre>
  
  <p>How can I ensure the HTML entities show as their character equivalents?  I'm surprised I wasn't able to find a Google answer.</p>
  
  <p>Thanks.</p>
  
  <p>Here's a larger snippet:</p>
  
  <pre><code>select
     stuff((
        select
           ', ' + SomeField + ' &lt;' + cast(count(AnotherField) as varchar(6)) + '&gt;'
        from
           SomeTable as SomeAbbrev
        where
           SomeField = SomeOutsideField
        group by
           SomeField
        order by
           SomeField asc
        for xml path('')
     ),1,1,'') SomeFields
  from
     blablabla
  inner join
     blablabla
  left join
     blablabla
  left join
     blablabla
  order by
     SomeDateField asc
  </code></pre>