I there a way to rewrite a SQL query, so I can avoid IFNULL or COALESCE, because the HXTT DBF JDBC driver (supports SQL92) throws the following error.:The following query causes the above error.:If I remove IFNULL or COALESCE, there is no error.