Documentation:OCLOperators sqlLike: Difference between revisions

OCLOperators sqlLike

Revision as of 06:55, 6 March 2023

This page was created by Hans.karlsen@mdriven.net on 2018-07-22. Last edited by Stephanie@mdriven.net on 2025-02-04.

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 % to say that "could be anything here."
-See also [[OCLOperators sqlLikeCaseInsensitive|sqlLikeCaseInsensitive]]
+See also: [[OCLOperators sqlLikeCaseInsensitive|sqlLikeCaseInsensitive]]
 [[Category:OCLOperators]]