Super

Many thanks

Xavier

>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