I’m used to using this syntax when employing filter tables to forms in HSQLDB:
SELECT * FROM "tbl_Users" WHERE ((UPPER("FirstName") LIKE '%' || UPPER (:Var_FN) || '%' ) OR (:Var_FN IS NULL))
I cannot get this to work in FireBird, and it seems to have to do with the second part in the WHERE clasue: “OR (:Var_FN IS NULL))”
What’s the alternative? I need a blank field to select all records from the filtered table.