title: SQL Replace comma in results without using replace
body: <p>I feel like this should be simple enough to do, but have not found any solutions that didn't use replace so far. I have the following select statement I am running, and for some of the columns there are commas separating the values. I would like to replace these commas with semicolons, however I only want to do it in the select statement. I don't want it to alter the values in the tables at all. This is not a one off statement either, or I'd just replace all the commas with semicolons and then revert back. </p>
  
  <pre><code>SELECT a.Category_Id, a.Category_Name, ISNULL(b.Category_Alias, '') as Category_Alias, 
  ISNULL(b.SUPPORT_NAMES, '') as SUPPORT_NAMES
  FROM Categories a
      INNER JOIN CategoryInfo b on b.Category_Id=a.Category_Id
  </code></pre>
  
  <p>For the Category_Alias column, the records are actually stored like <code>CS, Customer Support</code> and I want that to show up as <code>CS; Customer Support</code> just for the select statement.</p>