Hey, SQL Gurus!
I have very minimal experience with SQL code.
How can I link the EntityGLC table to the GLBudgetHd table through an SQL statement?
It looks like the field EntityGLC.GLControlCode contains GL Account Numbers in the format of XXXX-XX-XX whereas the field GLBudgetHd.BalanceAcct contains GL Account Numbers in the format of XXXX|XX|XX.
I would imagine that I need to use an embedded SQL statement that converts either the pipe to a dash, or the other way around, in order to link the fields.
I’m under the gun to get this completed quickly.
Am I way off base on my thinking?
Thanks in advance for your time.
Steven