Convert query from SQL to Hana: SAP Business One

[former_member698435]

Dear Experts,

I have this query that uses SQL syntax that I need to convert to Hana syntax. Your assistance would be very helpful.

Thank you!

Marli

SELECT CAST(T1.trgtPath AS nvarchar(4000)) + '\' + T1.FileName + '.' + T1.FileExt FROM ORDR T0 JOIN ATC1 T1 ON T0.AtcEntry = T1.AbsEntry WHERE T0.DocNum = $[$8.0.0]

[hdolenec · Accepted solution]

Try this

SELECT TO_NVARCHAR(T1."trgtPath") || '\' || T1."FileName" || '.' || T1."FileExt" FROM ORDR T0 JOIN ATC1 T1 ON T0."AtcEntry" = T1."AbsEntry" WHERE T0."DocNum" = $[$8.0.0]