title: SQL QUOTENAME adding single quotes and a comma
body: <p>I have a basic table which outputs.</p>
  
  <pre><code>field1
    a
    b
    c
  </code></pre>
  
  <p>Then i want to add single quotes and a comma so currently i have a simple QUOTENAME.</p>
  
  <pre><code>QUOTENAME(field1,'''')
  </code></pre>
  
  <p>Which outputs the following results.</p>
  
  <pre><code>field1
    'a'
    'b'
    'c'
  </code></pre>
  
  <p>But i cant figure out how to get the QUOTENAME to output results like this.</p>
  
  <pre><code>field1
    'a',
    'b',
    'c',
  </code></pre>