I agree. In general, when using SQLEXEC(), you have to use the syntax of the back-end database.
And it follows that, in order for us to answer this type of question, we have to know which back-end database you are using. There are many such databases in existence, and although the majority use a fairly standard syntax, there are many exceptions, especially regarding data types.
However, given that you mentioned the Microsoft reference manual, I will assume that you are using Microsoft's SQL Server as your back end. If so, you will probably use [tt]char(10)[/tt] rather than [tt]C(10[/tt]) to specify the data type. I say "probably" because there are other character dataypes as well, including [tt]varchar[/tt], [tt]nchar[/tt] and [tt]nvarchar[/tt].
I suggest that before going any further, you spend some time learning the basics of SQL Server syntax (the particular dialect is called T-SQL). You can't do any serious SQL development work without that knowledge, however well you know VFP.
Mike
__________________________________
Mike Lewis (Edinburgh, Scotland)
Visual FoxPro articles, tips and downloads