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

Users may experience the following error when running Constituent queries that filter using criteria under Phones and Phones>Specific Phones:

Error:  Query too complex. General ODBC Error:  [Microsoft][ODBC Error SQL Server Driver][SQL Server]Incorrect syntax near the keyword 'AND". Native error: 156
This is resolved in 7.96, patch 12, released in July-August 2018 and applied to databases in Blackbaud Hosting Services. If your database is installed locally, download and install the latest version and patch, if applicable.

Environment

 Raiser's Edge
 7.96
 7.96
 12

Was this article helpful?