When executing the following query on 22.0.602:
select listagg([E-Mail], chr(13)) from MY_PROD.dbo.[MY PROD$Element] where [E-Mail] is not null and length([E-Mail]) > 0 and [E-Mail] like '%@acme.com'
I receive the following error:
External error in Invantive Data Hub.
Incorrect syntax near ‘-’.
Must declare the scalar variable “@w1E”.
How can I run such a filtered query on a SQL Server table with a column named “E-Mail” (case sensitive, with a dash)?