this works in 2024 in Microsoft SQL server.

UPDATE table SET data = data + 'a'

The syntax is likely to be in place for many years already.