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

Write the content here to display this box

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