Double single quotes.

=SQLEXEC(hconnect, ;
  [Insert into Table (id) values ('] + CHRTRAN(myid, ['], ['']) + [')] )

>Hello,
>
>How can I send a field that contains quote to a SQL server using an SQL pass through ?
>
>=SQLEXEC(hconnect,"Insert into Table (id) values ('" + myid + "')")
>
>myid has single quote included for example.
>
>Thanks
>
>Xavier