I need to perform an update of a table row where there are 2 field, a pk and a counter field. I need to update the counter field to +=1 and then get the value it was updated to without performing a select.

Is this possible?

Thanks.