Hi
I have a small problem in my application. I have a search function. But the
search is case sensetive. And I do not want it to be that.
This is the code that do the search and I think it looks wrong. So I just
want to check with you .. Is this the way to use
SQL wildcards with prepared statements?
PreparedStatement prep = dbConn.prepareStatement("SELECT NoteID, Subject,
DocumentText FROM Note WHERE Subject LIKE ?;");
prep.setString(1, "%" + search + "%");
/Andreas
--
Andreas Henningsson
"Vanligt sunt förnuft är inte särkilt vanligt." -- Voltaire
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/h2-database?hl=en.
