'How to prepend '(' to a string

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?

sql firebird

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Solution	Source