yourtext=STRTRAN(yourtext,"'","\'")
yourtext=STRTRAN(yourtext,'"','\"')
You will need one line per special character, or you can combine it into one ugly looking line.
>Is there have simple way to put escape character infront some special char like ',"...
>
>
>For Example :
>
>
>Change from -
>
>INSERT INTO customer (cusNo,remark)
> VALUES ('C01','THIS'S A TEST, 123')
>
>To
>
>INSERT INTO customer (cusNo,name,ramark)
> VALUES ('C01','THIS\'S A TEST, 123')
>
>
>
>
>Thanks