How to List Items with Name ends with (xxx)

Scenario: The User wants to get the list of items, the name of the items ends with (-MR).

Create an Item saved search:

1. Go to Lists > Search > Saved Searches > New.
2. Select “Item” as the record type for the saved search.
3. Give a name to the saved search and click on the “Criteria” tab.
4. Formula (text)=

Formula: CASE WHEN {name} LIKE ‘%-MR’ THEN 1 ELSE 0 END

5. Save and Run

6. Validate the results