title: SQL rtrim select and group by
body: <p>If you put an rtrim in the SELECT and also again in the GROUP BY, is this inefficient because its rtriming twice, one in the select and one in the group by? e.g....</p>
  
  <pre><code>SELECT
  rtrim(people.FORENAME1)+ ' ' + rtrim(people.SURNAME)AS Full_Name,
  
  FROM 
  my table
  
  GROUP BY 
  rtrim(people.FORENAME1)+ ' ' + rtrim(people.SURNAME)
  </code></pre>