Documentation:OCLOperators sqlLike: Difference between revisions

OCLOperators sqlLike

Latest revision as of 15:43, 10 February 2024

In SQL databases, you have the Like operator. In OCL, we added this same functionality as SqlLike.

SqlLike works both in OCL and in OCL-PS.

SqlLike enables you to match part of strings like this:

Person.allinstances->select(a|a.Identity.sqlLike('%'+vSeekParam+'%'))->orderby(identity)

Add a % to say that "could be anything here."

@@ Line 1: / Line 1: @@
-In SQL databases you have the Like operator. In Ocl we added this same functionality as sqlLike
+In SQL databases, you have the Like operator. In OCL, we added this same functionality as SqlLike.
-SqlLike works both in OCL and in [[OCL-PS]]
+SqlLike works both in OCL and in [[OCL-PS]].
 SqlLike enables you to match part of strings like this:
   Person.allinstances->select(a|a.Identity.sqlLike('%'+vSeekParam+'%'))->orderby(identity)
-Add a % to say that "could be anything here"
+Add a <code>%</code> to say that "could be anything here."
-See also [[OCLOperators sqlLikeCaseInsensitive|sqlLikeCaseInsensitive]]
+See also: [[OCLOperators sqlLikeCaseInsensitive|sqlLikeCaseInsensitive]]
+[[Category:OCLOperators]]
+{{Edited|July|12|2024}}