>I know when we have ' we have to double it, there is another caracter that i have to double ????
>and what i do with the :
>thanks !

There are no characters you have to double if you use parametric insertions vs hardcoded. ie:

lcName = "O'hara"
SQLExec(m.lnHandle, "insert into myTable (myName) values (?m.lcName)")

Cetin