Given a prepared statement such as: SELECT x FROM t WHERE y = ?Is there any way to match all values of y by doing something like: preparedStatement.setString(1, ANY) This would be extremely handy for dynamic query construction.
perhaps with a trick - but i don't know how to bind "NULL" SELECT x FROM t WHERE NOT y<>? with ps.setNull(1, Types.NULL); should match any row in the table (because y<>NULL is always false) _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
