title: Concatenating single quotes around a section of a select statement
body: <p>The following is a section of my select statement </p>
  
  <pre><code>CAST(Table.field AS datetime) AS newDate
  </code></pre>
  
  <p>As you would expect, it returns something like the following</p>
  
  <pre><code>1/1/1900  2:45:00 PM
  </code></pre>
  
  <p>However, I need it to return that same value inside single quotes as seen below. But I am having a really hard time for the syntax of this, with a cast statement, with a column renaming. Hopefully you guys could be of some help?</p>
  
  <pre><code>'1/1/1900  2:45:00 PM'
  </code></pre>