trying to concatenate some string values in a formula but getting invalid expression. Tried this: {custbody_dp_opp_machine}, " ", {entitystatus} This works: CONCAT({custbody_dp_opp_machine}, {entitystatus}) But this errors: CONCAT({custbody_dp_opp_machine}, " ",{entitystatus})

oracle uses single quotes for strings

Also I think the CONCAT function can only have 2 arguments. Try using double pipes {custbody_dp_opp_machine} || ‘ ‘ || {entity status} (No CONCAT needed)

thank you. the || worked. is the double || the equivalent to the + sign?

I’ve never tried the “+” sign. I’ve only ever used double ||

|| messes me up because it randomly stopped working a while back in MySQL

I guess I am subconsciously using excel formula!

yep the MSSQL + is equal to oracle || just remember || is an OR in advanced pdf!