🚀 Welcome to MDriven Learn –  Don’t miss the latest Release Notes.
OCLOperators 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 enables you to match part of strings like this:

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

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

See also: sqlLikeCaseInsensitive