OQL alternative for REPLACE() ? - Mendix Forum

OQL alternative for REPLACE() ?

0

How to write the following in OQL?

     select REPLACE(actual_label, 'Unmapped_', '') actual_label, count(*) from…

Note the REPLACE() function is sql server. Does OQL have something similar? Or is there an alternative?

 

asked
1 answers
1

Hi Richard, 

I think you can use CASE for this scenario: https://docs.mendix.com/refguide/oql-case-expression

answered