When you want to match on strings - or part of strings - but ignoring case

It works just like sqlLike but ignores case.

Note!

sqlLike might ignore case in ps search - this depends on your database server and it's settings.

For example, the Turnkey built in database Sql Server Compact, does not ignore case. If you want easier search, use this operator.

Person.allinstances->select(a|a.Name.sqlLikeCaseInsensitive('%'+vSeekParam+'%'))