title: Inner join on LIKE sqldf
body: <p>How can I use the <code>LIKE</code> clause with an inner join using sqldf in R? </p>
  
  <p>The code:</p>
  
  <pre><code>Name &lt;- c("Jack","Jill","Romeo")
  Name &lt;- as.data.frame(Name)
  FullName &lt;- c("School Jack H", "School Juliet G", "College Jill M", "College Romeo F")
  Marks &lt;- c("100","82","54","0")
  FullBio &lt;- cbind(FullName, Marks)
  FullBio &lt;-as.data.frame(FullBio)
  </code></pre>
  
  <p>And then when I run:</p>
  
  <pre><code>sqldf("select a.*, b.* from Name a join FullBio b on a.Name like '%'+b.[FullName]+'%'") 
  </code></pre>
  
  <p>returns 0 rows.</p>
  
  <p>Why? What are my other alternatives please. I apologise for making you create so many variables to run my code.</p>