title: RODBC and sqlQueries with R objects
body: <p>I got a special problem I try to standadize SQL queries since they come up several times in my file.</p>
  
  <p>An example.</p>
  
  <p>at the top I want to define the column name and the table</p>
  
  <pre><code>Testquery &lt;- c("COLUMN1")
  Testtanle &lt;- c("TABLE1")
  </code></pre>
  
  <p>Down the road in my code I want this to be implemented in a SQL query</p>
  
  <pre><code>Newvector&lt;-sqlQuery(channel, "SELECT" Testquery "FROM" Testtanle)
  </code></pre>
  
  <p>Of course I run into problems with the <code>""</code>. Anyone an Idea how to handle this?</p>
  
  <p>Thanks in advance</p>