General ODBC Error: [Microsoft][ODBC SQL Server Driver][SQL Server]The data type text cannot be used as an operand to The UNION, INTERSECT or EXCEPT operators because it is not comparable. Native error:5335 - when using a search window in Raiser's Edge

Error: Error loading grid: General ODBC Error: [Microsoft][ODBC SQL Server 
Driver][SQL Server]The data type text cannot be used as an operand to 
The UNION, INTERSECT or EXCEPT operators because it is not comparable.
Native error:5335
[Microsoft][ODBC SQL Server Driver]The cursor was not 
declared. 
Native Error:16945
Search Window, using Query/Classic Search View in conjunction with "Use Enhanced Search" causes the error above. This can occur if your Query contains the "Annotation" output.

If using a Query:
1. Open Query being used
2. Output tab
3. Remove the Field: Annotation

OR

Uncheck "Use Enhanced Search" in the Search Window (Note: This option only appears as selectable if you have entered information in a search box, such as, Last Name, First Name, etc. In your Search Window)

Steps to Duplicate

Steps to Duplicate:
1. Records > Constituent
2. Open Constituent
3. Search using Query: <Include a Query>
4. Last Name: <Enter any name>
5. Click Options
6. Choose "Show Classic Search View When Using Enhanced Search"
7. Checkmark "Use Enhanced Search"
8. Click "Find Now"
9. Receive Error:
Error loading grid: General ODBC Error: [Microsoft][ODBC SQL Server 
Driver][SQL Server]The data type text cannot be used as an operand to 
The UNION, INTERSECT or EXCEPT operators because it is not comparable.
Native error:5335
[Microsoft][ODBC SQL Server Driver]The cursor was not 
declared. 
Native Error:16945

Was this article helpful?


Thanks for your feedback! Did this solve your issue?

Comments (optional):


Thanks for your feedback!
We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.
We’re sorry to hear that. Please tell us why.

 I don't like how this works.

 The answer is confusing.

 The answer didn't match what I was searching for.

Additional Comments (optional):


Thanks for your feedback! If you need assistance, click Chat with Support below.
Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.
Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.
Thanks for letting us know. We'll work on updating the search engine to return more relevant results.