Search Errors and the RTRIM Function

Problem: When performing a search with "does not end with" search criteria, all the rows are shown.

Solution: If your table includes the char column, you can use SQL with rtrim(column name) as the column name in the MBO definition. For example:

SELECT   dept_id,
           rtrim(dept_name) as dept_name,
           dept_head_id 
  FROM sampledb.dba.department