Documentation:OCLOperators sqlLikeCaseInsensitive: Difference between revisions

OCLOperators sqlLikeCaseInsensitive

Latest revision as of 07:52, 17 June 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 95 days ago on 06/17/2024. What links here

Revision as of 15:43, 10 February 2024 (view source) Wikiadmin (talk \| contribs) (Automatically adding template at the end of the page.) ← Older edit		Latest revision as of 07:52, 17 June 2024 (view source) Wikiadmin (talk \| contribs) (Replacing message template with parser tag)
(One intermediate revision by the same user not shown)
Line 1:		Line 1:
			<message>Write the content here to display this box</message>
	Use this when you want to match on strings - or part of strings - but ignore case.		Use this when you want to match on strings - or part of strings - but ignore case.