ODBC connection gives error when filtering on a boolean field

I have an ODBC connection that has entities with boolean fields. When I try to create a query filter on one of these fields, I get the following error:

 

ERROR: Exception Type : InvalidExecuteQueryException 

Message : The following error has occurred in the ODBC Connector: ERROR [42S22] [Microsoft][SQL Server Native Client 10.0][SQL Server]Invalid column name 'False'. 

 

The field map shows the field as a boolean type and I've tried all of the following values with no luck: false, 'false', 0, FALSE()

Login