Concatenate three fields that are separated by a special character

Trying to concatenate three fields separated by different special characters using the Formula In-DB tool. Thought the below formula would work but i am getting a syntax error. Not sure what I am missing.

[fieldname1] + "-" + [fieldname2] + "Z" + [fieldname3]

Error Message

Accepted answers

MarqueeCrew

This answer is based on an Oracle RDBMS.

fieldname1 || '-' || fieldname2 || 'Z' || fieldname3

SQL server is:

fieldname1 + '-' + fieldname2 + 'Z' + fieldname3

Cheers,

Mark

All comments

MarqueeCrew

This answer is based on an Oracle RDBMS.

fieldname1 || '-' || fieldname2 || 'Z' || fieldname3

SQL server is:

fieldname1 + '-' + fieldname2 + 'Z' + fieldname3

Cheers,

Mark

cstafford

Hi Mark,

Thanks for the assistance and direction. Took some trial and error but this was the final formula. The column names needed quotes.

"fieldname1" || '-' || "filedname2" ||'Z'|| "fieldname3"

CARLOS_ROM

GRACIAS ASI SE SOLUCIONO.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703