Jeff – Sorry for disappearing, but for some reason I missed your response. What I wanted to do was very simple. I was working on improving performance on a stored procedure. One of the changes that I've made was to make fewer data access statements. In the procedure there was a code that looked like that:

Select @OldValue = Col1 from MyTable where PK=X

Update MyTable SET Col1 = NewValue where PK=X

I wanted to access the table only once instead of twice.

Adi