OpenOffice Base LIKE with columns

Question

I have an Open Office database. I'd like to use the LIKE operator with "%" marks between two columns in the same table:

SELECT * FROM "table1" WHERE UPPER ( "table1"."a" ) LIKE UPPER ('%' + "table1"."b" + '%' )

But it doesn't work, although

SELECT * FROM "table1" WHERE UPPER ( "table1"."a" ) LIKE UPPER ("table1"."b")

works. What's wrong in my syntax?

xQbert · Accepted Answer · 2011-12-21T23:24:20.477

1

Missing a + on the front after the % and before table.

SELECT [insert your fields here] FROM "table1" WHERE UPPER ( "table1"."a" ) LIKE UPPER ('%' + "table1"."b" + '%' )

Updated

SELECT [insert your fields here] FROM "table1" WHERE UPPER ( "table1"."a" ) LIKE '%' + UPPER("table1"."b") + '%'

I'm assuming A and B are both of the same data type.

I'm assuming + is an string concat in openoffice. other possible values are || or &

edited Dec 21 '11 at 23:24

answered Nov 10 '11 at 16:50

xQbert

Sorry, I copied my code wrong. Your code (which is my original code) doesn't work. I'll edit my post – balping Nov 10 '11 at 16:54
Thanks your help! That works. (But I can't understand why didn't my code work... OpenOffice is chaotic) – balping Nov 10 '11 at 17:16
Wish I could tell you. I don't know open office database very well. I just know to simplify operations when attempting to troubleshoot. – xQbert Nov 10 '11 at 17:23
**Never use *, always define the fields.** – zerkms Dec 21 '11 at 23:14
String concat is `||` in LibreOffice Base. – user149408 May 15 '19 at 13:25