Java application. After I put a cursor in a search field (String) and click on space bar, I got an error: my WHERE clause with LIKE stops working. ( I use a delimiter(" ") in this search.)
How should it work if only a space character is entered? We need to trim it out and treat it as nothing entered at all. However, String.trim() doesn't work here.