Hi, sorry for the late response. Could you describe the real scenario please? >
For example we have next table with "ignorecase=true": +-------------+----------------+ | *Prefix* | *Name* | +-------------+----------------+ | Mr. | Max | +-------------+----------------+ | Mr. | Thomas | +-------------+----------------+ | Mr. | Mike | +-------------+----------------+ | Ms. | Mona | +-------------+----------------+ User can search by some kind of object presentation: ---------------------------------------------------------- SELECT * FROM table WHERE CONCAT(Prefix, ' ', Name) LIKE '%mr. m%' ---------------------------------------------------------- There are no results for search by concated values, but expected 2: Max, Mike. Regards, Max -- 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 http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/groups/opt_out.
