Hi!

Take a look to SQLEXEC() command. Write commands for SQL Server in the Query analizer, copy them and paste into the VFP program making them as a single string, then use SQLEXEC(nHandle,strBatchCommands) command. Beware, such commands list should not include "GO" and question marks ("?"). Go is used by query analizer only to separate batches of commands. "?" is a special symbol in SQLEXEC() in VFP that used for parameters (data) passing to the SQL Server. This way you can prepare the string with a lot of T-SQL commands and run them all at once.

>Dear all,
>
>Can I use a single SQL command to alter the type of column on SQL Server? I know that I can use ALTER TABLE ALTER COLUMN to change the type of column, but it just only change one column at a time. Thank you for your help and advice..
>
>Best Regards,
>
>Justy Chow