>Hi,
>
>I think I can sent two command to SQL Server from VFP app (using SQLEXEC()) but I am not sure what separator to use. Should it be semi colon? For example if I want to alter a column and then set a value into this column, can I do the following:
>
>

>cSqlCmd = "alter table MyTable alter column MyFld1 char(30); update MyTable set MyFld1 = repl('0',30) where len(MyFld1) = 0"
>nRetunr = SQLEXEC(nConn, cSqlCmd)
>

>
>Will the above work? TIA
>
>UPDATE. I ran it and it works.

Yes, you can and should use semicolon. You can also use text endtext to put commands in multiple lines to improve readability.