>>Hi All:
>> How can I modify that table in a Sql Server if the selected table is not empty. I.E. I am trying to add an extra field to the table on Sql Server that alreday has records in it.
>>Thanks
>
>alter table mytable add column column_name data_type

That would be the syntax for VFP. Leave COLUMN out and it would run in SQL Server without errors.