Concatenate three fields that are separated by a special character

[cstafford]

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]

[MarqueeCrew · Accepted solution]

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.