I agree the best answer would have been UPDLOCK, but that was not an option. Since B only specified a UPDATE locking hint, it was incorrect, since there is no such thing as a UPDATE locking hint.

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples