One idea would be to run a SELECT count() with the same WHERE clause before running the update.

>When I execute an SQL update via ODBC in an Active Server Page script (using the VFP ODBC driver), how can I determine how many records were actually affected by the update? Thanks!