Concat function - how to add an apostrophe to a string?
How would you concatenate an apostrophe in front of a string?
Assume I wanted to produce the string 'Hi
= Concat('Hi','Hi') yields the string HiHi
= Concat(''','Hi') yields missing operator before the Hi operand message
The formulas use SQL syntax, so ' is used as the start and end character of a string. To make ' be a part of the string, you have to escape it with a second '. In short, you'd need this:
Thanks for responding.
That is one of the first things I tried, but I got a different result when I View the Inquiry.
I get ''Hi as a result (2 leading apostrophes).
Using Acumatica 2018 R2 with customizations.
Maybe that has something to do with it.