I have ran both above query. Below are the screenshots.

I have already verified the data with LAB person and we have confirmed that the problem with special character single quotes '. 

I have ran the both query. Below are the screenshots.

Up to 256 no issue because there is no special character single quotes in callbackcomment field. but 257 row has callbackcomment field with single quotes and it is given the error. verify below screenshot.

I have no developer access to cache

I have run same query for 10th April. Below is the details. 

When I was selecting other field, there was no error. The problem is only with "CallbackComment" filed.

Also same for %INTERNAL and %ODBCOUT

Thanks for the Answer. But I'm new to this cache domain, Could you please provide me the modified query that i can run using management portal.

Sorry Community, I was trying to hide some information because of our company policies.

Below is the brief  details.

We have application which has one script. That script is using SQL query which i have already mentioned. so that SQL query is giving us the error like "ODBC read failed" in that application.  So i have verified the Inter System ODBC connection and that is working fine. So for more investigation, I have connected to cache database using cache management portal. There i have set the ODBC mode and I have executed that same SQL query,  And i got the error "CSP application closed the connection before sending the response". So manually i have verified the data and found out that whenever single quotes is come in data, it is giving this error. SO this is the scenario.

Please give your suggestion and let me know if you have any question.

Thanks in Advance. 

1. Yes, We have index on PhoneDateODBC

2. As i have mentioned that i am using the Intersystem ODBC driver to connect the cache database. And it is failed to read special character single quotes. so please gives some details about that.