Documentation:OCLOperators sqlLikeCaseInsensitive: Difference between revisions

OCLOperators sqlLikeCaseInsensitive

Latest revision as of 15:43, 10 February 2024

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

This page was edited 96 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
+Use this when you want to match on strings - or part of strings - but ignore case.
 It works just like [[OCLOperators sqlLike|sqlLike]] but ignores case.
@@ Line 5: / Line 5: @@
 '''''Note!'''''
-sqlLike ''might'' ignore case in ps search - this depends on your database server and it's settings.
+[[OCLOperators sqlLike|sqlLike]] ''<u>might</u>'' 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 easier search, use this operator.
+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+'%'))
 [[File:2018-07-22 11h09 10.png|none|thumb]]
+[[Category:OCLOperators]]
+{{Edited|July|12|2024}}