I have a MySQL 5 database. I have a limited PHP web interface to update and display data to & from MySQL. PHP is escaping out ' characters fine, no problem here.

My main interface is on Filemaker 8.5. This is where all the data is created and updated. It's working great using import and MySQL commands with Actual Technologies ODBC. HOWEVER it does not escape the ' characters and produces ODBC errors. I've tried the substitute command in Filemaker, but it doesn't substitute ' for '. Not a major problem, just can't use those 's. Any ideas??? THANKS

Substitute should work fine to replace the single quote with escaped ones, but you probably need to turn off "smart quotes" before making the calculation. That has bitten me numerous times.