I know you could do this thru a Stored Procedure. There's a variable in SQL Server called @@Rowcount that will have the number of rows affected. If you're just doing this thru SPT with a statement, I'm not sure how to access Rowcount.

PF

>Is there any way that SQL server 6.5 can tell me if a conditional update was successfully executed.
>
>eg. update table.field with value+1 where table.field = value
>
>This example will always return a 1 but I want to know if the condition was met and if the field was actually updated. Can anybody help.
>
>
>Chris