Error: General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'AND'. Native error:156

When adding multiple Activity, Summary, Record aging balance criteria to a record query, users will receive the following error.

Error: General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'AND'.
Native error:156

Download and install the latest version and patch, if applicable. 

Environment

 7.82.104, patch 37
 7.87.164

Was this article helpful?