Mike,

To use sqlexec() do the following

text to lcSql noshow textmerge pretext 7
insert into mytable (colu1,col2...)
values (<<nval1>>,'<<cval2>>') 
endtext 

?sqlexec(lnYourHandle,lcsql) 

with chr() values you have to add a ' outside of the <<>>.

Another option

text to lcSql noshow textmerge pretext 7
insert into mytable (colu1,col2...)
values (?nval1,?cval2) 
endtext

?sqlexec(lnYourHandle,lcsql) 

>Hello,
>I have a cursor and I want to append it to a SQL Server table. I have to use SQLEXEC though. I know how to do it when you add the table to the designer, but now I am stumped and and can't seem to find the right documentation. TIA!
>
>MAC