I have a column with 4 numbers, for example 1234. I need (1234) // between brackets

update table set column=overlay(column placing ')' from 5) where table_ID=1 

I get 1234) --> missing the first bracket. Any suggestions?

CodePudding user response：

The simplest way:

update table set column='('||column||')' where table_ID=1