This returns 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"

 

 

Alternatively, you can use the concat function. This is supported by MSSQL and HANA.

select concat('Martin',' Heigl') from "BEAS_DUMMY"