🚀 Welcome to MDriven Learn –  Don’t miss the latest Release Notes.
OCLOperators sqlLikeCaseInsensitive

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 a 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+'%'))