In my Java application I use prepared statements for filtering a table. I want to be able to filter strings, which works fine already. But I also need to specifically find records with empty strings in the table, which does not work using the LIKE condition.
Here is the SQL statement I use:
String FIND_BAS =
SELECT * FROM LIC_SEARCH_BA
WHERE BASTATUSID LIKE ? AND COMPANY LIKE upper(?) AND NAME_UPPER LIKE upper(?) AND BANUMBER LIKE ?";
How can I change it to find also records with empty BANUMBER for example?
[Updated on: Wed, 15 October 2008 11:49] by Moderator
Report message to a moderator