1 Reply Latest reply on Mar 14, 2006 9:17 PM by Julian Klappenbach

    Query Language case-insensitive Like

    Bernhard Hurzeler Novice


      Is it possible to do a case-insensitive LIKE query with EJB3. If yes how if not is there another way to do this.

      SELECT OBJECT(s) FROM Site AS s WHERE s.name LIKE '%test%'

      I want also 'TEST' as a result.

      Thanks for your help.