Question

Like Expression In OQL Statement

2

I am writing an oql statement where like expression is used , how i can entertain special character %,’ as its throwing error and their are records with these characters.

asked 2023-04-27

Anas Mateen

1 answers

Chris de Gelder · Answer 1 · 2023-05-01

% needs to be escaped with \

https://docs.mendix.com/refguide9/oql-operators/

City LIKE '%dun' returns all the cities with names that end with ‘dun’, like ‘dun’ and ‘Losdun’.
Symbol LIKE '%\%' returns all the symbols that end with the % special character.