Documentation:OCLOperators sqlLikeCaseInsensitive: Difference between revisions

OCLOperators sqlLikeCaseInsensitive

Revision as of 11:02, 22 July 2018

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

This page was edited 97 days ago on 02/10/2024. What links here

@@ Line 1: / Line 1: @@
 When you want to match on strings - or part of strings - but ignoring case
-It works just like [[OCLOperators sqlLike|sqlLike]] but ignores case (sqlLike might ignore case in ps search - this depends on db settings )
+It works just like [[OCLOperators sqlLike|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+'%'))
 [[File:2018-07-22 11h09 10.png|none|thumb]]