Search code examples
sql-serverhana

Concatenate two columns in HANA database


Please give me an advice to convert below MSSQL VIEW to HANA VIEW

CREATE VIEW [dbo].[ViewSample]
AS
SELECT [column1] + ' / ' + [column2] AS CollectionLabel
FROM [dbo].[T1] T1
CROSS JOIN [dbo].[T2] T2

Thanks in advance


Solution

  • How about CONCAT twice?

    CREATE VIEW "dbo"."ViewSample"
        AS
        SELECT CONCAT("column1", CONCAT(' / ', "column2")) AS CollectionLabel
        FROM "dbo"."T1" T1
        CROSS JOIN "dbo"."T2" T2