OCLOperators sqlLikeCaseInsensitive
This page was created by Hans.karlsen on 2018-07-22. Last edited by Stephanie on 2025-02-12.
Use this when you want to match on strings - or part of strings - but ignore case.
It works just like sqlLike but ignores case.
Note!
sqlLike might ignore case in ps search - this depends on your database server and its settings.
For example, the Turnkey built-in database Sql Server Compact does not ignore case. If you want an easier search, use this operator:
Person.allinstances->select(a|a.Name.sqlLikeCaseInsensitive('%'+vSeekParam+'%'))