Documentation:OCLOperators sqlLikeCaseInsensitive: Difference between revisions

OCLOperators sqlLikeCaseInsensitive

Revision as of 07:03, 6 March 2023

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 97 days ago on 02/10/2024. What links here

Revision as of 06:56, 6 March 2023 (view source) Stephanie Namugambe (talk \| contribs) No edit summary Tag: Visual edit ← Older edit		Revision as of 07:03, 6 March 2023 (view source) Stephanie Namugambe (talk \| contribs) No edit summary Tag: Visual edit Newer edit →
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.		It works just like [[OCLOperators sqlLike\|sqlLike]] but ignores case.