Trigger before update a fields in a table
The answer will vary depending upon the RDBMS you are using. Also DBAs &amp; developers have different preferences.

Personally i would choose to apply this in a stored procedure rather than a trigger. Triggers dont scale well and can give unpredictable results with bulk updates.