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