[Hsqldb-user] select like Lower/Upper case

[Michael P. <mic...@pu...>]

Hello,

i want to select some values of my db with like.
But without the differentes between upper and lower cases.

How i could do it?

This is my current select: select * from table where name like '%Schmitz%'

Thx

Michael