Dear nafg, you may use ILIKE.
"ILIKE does a case-insensitive compare." (http://www.h2database.com/html/grammar.html) Best regards, Tonke Am Montag, 17. August 2009 19:48:03 UTC+2 schrieb nafg: > > How can I do a case insensitive LIKE query? I need to search any field > if it contains certain text. > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
