title: Single quote in a query
body: <p>How can I insert an single quotes in a query ?</p>
  
  <p><strong>Example</strong></p>
  
  <pre><code>select *, 'INSERT INTO San_Endereco (Endereco_Id, Logradouro_Id, Bairro_Id, CEP, Logradouro, Livre) VALUES 
  (' + CAST(Endereco_Id as varchar) + ','
  + CAST(Logradouro_Id as varchar) + ','
  + CAST(Bairro_Id as varchar) + ','
  + CAST (CEP as varchar) + ','
  + CAST(Logradouro as varchar) + ','
  + CAST(Livre as varchar) + ')'  as teste
  FROM San_Endereco
  </code></pre>
  
  <p>Before each <code>CAST</code> I need put the single quote. How can I do that ?</p>