Requirement for this operator is H2 version 1.4.194 (2017-03-10).

Am Freitag, 12. Januar 2018 16:01:21 UTC+1 schrieb Tonke Hanebuth:
>
> 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.

Reply via email to