like in sap hana string concatenation code example

Example: concat function in hana sql

SELECT CONCAT ('C', 'at') "concat" FROM DUMMY;