OCLOperators sqlLike

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

This page was edited 95 days ago on 06/17/2024. What links here