OCLOperators sqlLike
This page was created by Hans.karlsen on 2018-07-22. Last edited by Stephanie 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."
See also: sqlLikeCaseInsensitive