When building ODBC lookup zones, Umango will build the SQL query for you and it will attempt to accommodate the necessary single quotes around the search criteria. However, when searching a text field using numeric data, a data type mismatch error can occur. To accommodate this scenario, add the workaround below to your SQL query. The query below assumes the field AlphaNum is a text data type.
Select * from [MyTable] where [AlphaNum] = <SearchValue>
Select * from [MyTable] where [AlphaNum] = Replace(<SearchValue>,'','')
Link to this article http://umango.com/KB?article=114