concat with + in sql code example
Example 1: concatenation in sql
We use "||" to concatenation in Sql
example:
WHERE LOWER(FIRST_NAME || LAST_NAME) LIKE '%d%' ;
Example 2: concat function in hana sql
SELECT CONCAT ('C', 'at') "concat" FROM DUMMY;