SQL query issue

When using SQL queries in the database node, why is the LIKE operator case sensitive. I.e. ‘KNIME’ and ‘Knime’ would not return the same results. Is there any way to search case insensitive.

Simon.

Hi Simon,

I think that this is a feature of the database you are querying (not of KNIME) and thus the behaviour of “like” will depend on the database/table/index configuration. You could do something like “UPPER(FIELD) LIKE ‘KNIME’”, but that can be an expensive query (e.g. full table scan).

So, in case of doubt: Ask your database administrator.

Best regards,
Nils