On Thu, 2007-03-22 at 20:48 -0400, Martin Gainty wrote: > Greetings > > Select COLUMN FROM TABLE WHERE (some condition) for UPDATE OF COLUMN > is not supported? > Yes, it is supported. > what would happen in a Table Deadlock scenario??? The deadlock detector detects the deadlock, causing one transaction to be aborted with an error. What kind of deadlock scenario are you concerned about? Regards, Jeff Davis