title: Distinct SQL Statement error
body: <p>I'm trying to do a statement to only select distinct records based on the <code>legacy_call_id__c</code> field, but I'm not sure how to do that.  I am getting an error,</p>
  
  <blockquote>
    <p>Msg 8163, Level 16, State 3, Line 1 The text, ntext, or image data
    type cannot be selected as DISTINCT."</p>
  </blockquote>
  
  <pre><code>SELECT DISTINCT Name, CreatedDate, clientId__c, completedDate__c
    , Legacy_Call_ID__c, Description_Short__c
    FROM Customers.dbo.Incident__c
    WHERE Description_Short__c LIKE 'New Hire%'
      OR Description_Short__c LIKE 'Term%'
  </code></pre>
  
  <p>I'm using SQL Server 2008R2 if that makes a difference.  Thanks!</p>