2 of 2 people found this helpful
You have 2 quotation mark in the end of the ACCOUNTNO B6021659902$`H4;_''
In the query there should be in the end of the ACCOUNTNO 5 quotation marks
Try to run the next Query
select top 1 ONDATE, ONTIME from GOLDMINESQL.DBO.CAL where ACCOUNTNO = 'B6021659902$`H4;_''''' order by ONDATE, ONTIME and it should work.
What I can suggest for solving this error problem is to create a new Contact Record and then merge the old record to the new record.
Thanks for you help Shaul. I couldn't get the query to return any records but I was able to find the record by the Account #, create a new record and merge the old record into the new one.