title: how to add single quote to the end and beginning of value retrieved in select statement
body: <p>I have a select sql which returns a string like joe','rose','chandler
  I need to get the result like 'joe','rose','chandler' using sql
  I am trying to use || but not successful.</p>
  
  <pre><code>SELECT '''||NAME||'''
  FROM 
  (SELECT REPLACE(joe,rose,chandler, ',' ,''',''') AS NAME
  FROM TABLE.
  </code></pre>
  
  <p>joe,rose,chandler is the value retrieved from column of Table.</p>
  
  <p>Now the NAME is being treated as a string rather than a value retrieved from sql.
  Can any one please help.</p>