try using a "like" with "Sync Master 2124" in the query. I''ll be the parenthesis are messing the query up....
I tried input exactly same string to create a query on my 8.8 core, I did not get the error. You may run the same SQL statement against your database and see if that is supported. If supported maybe there is some corrupt data in the database. You might consider to run DBrepair.exe.