Hi!

Well, it is possible - there are SQL Server functions for this (or system variable RowCount? I do not remember, just ask at the SQL Server forum). Most likely you will require to use stored procedure for this purpose

HTH.

>Dear Vlad Grynchyshyn,
>
>Thank you for your help and I tested. It returned no. of records processed using VFP Native SQL Command. When I use SQLExec to issue the SQL command via ODBC, it can't. Do you know have any way to return no. of records processed? Thanks a lot....
>
>Best Regards,
>
>Justy Chow