title: Removing last comma in SELECT statement
body: <p>I have a select query which looks like this:</p>
  
  <pre><code>SELECT 
  ROW_NUMBER() OVER (ORDER BY T.TitleId) as Row, 
  T.TitleId as TitleID, 
  T.TitleSort as TitleName, 
  TT.Description as TitleType, 
  TS.Description as TitleOrigin,
  --get genres
  (select Genre.Description + ', ' from Genre where GenreId IN
  (Select GenreId from TitleGenre WHERE TitleId = T.TitleId)
  group by Genre.Description for xml path('')) AS Genres, ....
  </code></pre>
  
  <p>This code works, but I can't find a way to get rid of the last comma. This is how the returned row looks:</p>
  
  <pre><code>Action, Drama, Romance, 
  </code></pre>
  
  <p>I need to get rid of last comma without using a function or declaring a variable, right here in the query. Is that possible? Thanks in advance for your answers.</p>