>>>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.

Thanks. I know VFP and Oracle syntax for that particular command is the same in both. I was hoping SQL Server would follow something that basic the same way. Oh well.