Informix apostrophe SQL error

I get [Informix][Informix ODBC Driver][Informix]开发者_如何转开发A syntax error has occurred when running the query below. When I remove the double apostrophes the query executes successfully. Everyth