>INSERT INTO employee (EmpNo, LastName, FirstName,
> PhoneExt, HireDate, Salary)
> SELECT EmpNo + 200, LastName, FirstName,'000',
> HireDate, Salary + 1000
> FROM empins
>
>Evidently VFP uses different syntax than SQL server or it simply can't insert data based on the results of a select statement.
MSKB#
259274 deals with this. It predated the addition of the syntax in 8, as was mentioned above, but it does suggest how to work around it.