Can you log a JIRA with schema of table with sample data. I will debug and fix the issue.
I see the issue, it is similar to http://stackoverflow.com/questions/5608584/how-to-query-mongodb-with-like-using-the-java-api
Funny thing is I have the right code commented out for some reason, can't think why I choose this way to begin with? Either case I logged [TEIID-2727] Like operator does not work in MongoDB translator