Hi, > But the search is case sensetive. And I do not want it to be that.
Could you use UPPER(Subject) LIKE UPPER(?). Or you could use CAST(Subject AS VARCHAR_IGNORECASE) LIKE ?. > Is this the way to use SQL wildcards with prepared statements? You could use '%' || ? || '%' (be sure to escape the search string correctly). Maybe in your case real fulltext search would be better / faster (see the docs). Regards, Thomas -- 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.
