Thank you for your attempted assistance, HOWEVER, my question was how do I do it in a SQL Expression. I am quite familiar with the formulas but I would like it in a SQL expression. I am using an Oracle 7 ODBC connection. I don't find there is much documentation out there on the syntax to be used in SQL expressions. Can someone else help me please?
Hi,
As an added note, why use ODBC..The Oracle Server ( the native connection) is much more efficient - although I do not know if it is available for such an old and desupported database ( Oracle7?),,( At least desupported by Oracle)
To Paraphrase:"The Help you get is proportional to the Help you give.."
Thank you for your assistance. This is what I was putting:
PS_TBLA."ORG" + '-' + PS_TBLB."DESCR"
and I get an invalid identifier.
Other options I considered were the {fn CONCAT(, )} but I don't know how to get the "-" in there. Or the {fn INSERT(, , , )} but I can't find proper instructions on how to use that.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.