Add/Append value to exisiting field

SQL++
1

Hello,

I want to add a value to an existing field as a prefix. I know how to update fields but I have no clue how I get the reference to the existing value to concatenate it.

Example:

Before:
{
“type”: “world”
}
After:
{
“type”: “hello_world”
}

Thanks in advance

2

I found the solution. It works with the CONCAT() string function.

3 
type || "_world"
CONCAT(type, "_world")
CONCAT2("_",type,"world")