Hi, Charles
If you look at my first post, I believe that I said this was already done. When I look at the string from VFP's debug window, I looks like this.
'"BAR.000000",00,"BAR"'

Thanks.
>Hi,
>
>I think you need to pass your values comma delimited with quotes around each value.
>SQL also wants a double single quote around strings with quotes in them.
>
>Try using STRTRAN to add the double single quote and quotes between commas.
>
>example
>
>stringtxt = "dave,o'brien,23,bar.000"
>insertline = "insert into tmptable values('" + STRTRAN(STRTRAN(stringtxt,"'","''"),",","','") + "')"