There is a complex requirmeent to fetch records from a particular table. We need to get it through a function alias with Startswith as doing joins with subreports will slow down things. Is there any OOTB function alias to check startswith in function aliias. Existing function alias pxstartswithspecialchars is not helping in this scenario.

I tried creating a new function Alias with the following code, but it did not work:

CASE WHEN {1} LIKE 'MTM%' THEN {2} ELSE {3} END

We want to check if it starts with MTM, we will show something , if it does not starts with MTM, we will show something else. Any help in this regard would be very helpful, Thanks