This return the concat property for current used server
MSSQL: return +
HANA: return ||
for writing stable sql statements for HANA and MSSQL you can use this placeholder
select 'Martin'<sqlca.concat>' Heigl' from "BEAS_DUMMY"
in MSSQL:
select 'Martin' + ' Heigl' from "BEAS_DUMMY"
in HANA
select 'Martin' || ' Heigl' from "BEAS_DUMMY"
Alternative you can use concat function. This is supported by MSSQL and HANA
select concat('Martin',' Heigl') from "BEAS_DUMMY"