You want a result, or you do you want to update the result set so that a column has a particular value?

As Chris pointed out, Returning a Resultset in a trigger is deprecated, so you're better finding a different solution if you are somehow making use of the resultset returned upon update (like a separate SELECT statement).