title: OpenOffice Base LIKE with columns
body: <p>I have an Open Office database. I'd like to use the LIKE operator with "%" marks between two columns in the same table:</p>
  
  <pre><code>SELECT * FROM "table1" WHERE UPPER ( "table1"."a" ) LIKE UPPER ('%' + "table1"."b" + '%' )
  </code></pre>
  
  <p>But it doesn't work, although</p>
  
  <pre><code>SELECT * FROM "table1" WHERE UPPER ( "table1"."a" ) LIKE UPPER ("table1"."b")
  </code></pre>
  
  <p>works. What's wrong in my syntax?</p>