Search Errors and the RTRIM Function

Problem: When performing a search with "equals" and "ends with" search criteria, you see an Unable to find... message on the device at runtime.

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
Parent topic: Mobile Business Object Errors
Related tasks
No Data or Images Appear on the Device
Binding an MBO to a Database Fails
Structure MBOs Not Automatically Generated After Rebinding
Multilevel Insert Operation Fails
Related reference
Troubleshooting MBOs
Troubleshooting Improperly Designed Mobile Business Objects
Database MBO Fails on Execution
Web Service MBO Sync Exceptions After an Interface Change
Update Operation Fails
Relationship Error
SQL Statement Yields Unexpected Results
Warning Message When Creating Relationships
Synchronization Fails if Binary Attributes Have Unspecified Length