I've created a database that references a Calc document. I get an "Invalid Statement" error trying to use the following SQL statement
SELECT "Tabelle1"."A" AS "A", "Tabelle1"."B" AS "B", "Tabelle1"."C" AS "C" FROM "Tabelle1" AS "Tabelle1" WHERE ( LOWER ( "Tabelle1"."A" ) LIKE 'g%' ) The same statement works fine on a HSQL database. If I either remove the "LOWER" or replace "LIKE" with "=" the statement works on the Calc database. So apparently it is the combination of LIKE and LOWER that the Calc database can't process. Does someone know a workaround for doing case-insensitive pattern searches in a Calc database? Matthias p.s.: As this seems to be a bug I've opened issue 75557 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
