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"