title: Replace() in SQL isn't working with "
body: <p>I'm receiving a JSON string into a database which I'm trying to convert into a comma delimited list. This is my current state:</p>
  
  <p><a href="https://i.stack.imgur.com/04w5B.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/04w5B.png" alt="enter image description here"></a></p>
  
  <p>My SQL currently looks like:</p>
  
  <pre><code>BEGIN TRANSACTION
  
  SELECT  Id, 
          PriorityGroups ,
          REPLACE(
              REPLACE(
                  REPLACE(PriorityGroups, '["', ''), 
                      '"]', ''), 
                      '"."', ', ') AS 'Updated to comma delimited'
  FROM    dbo.CA
  WHERE   Id= 51
  
  ROLLBACK TRANSACTION
  </code></pre>
  
  <p>For whatever reason when I try to replace </p>
  
  <blockquote>
    <p>"."</p>
  </blockquote>
  
  <p>With a comma and a space it's not making any changes to the output. I've tried escaping the double quotes but I'm being told it's invalid syntax and I'm not too sure what else to try!</p>