How to compare two comma separated strings in hana

373 Views Last edit Jul 20, 2019 at 04:54 AM 2 rev

Hello All,

I have 2 variables whitch stores column names of hana tables and source files.

sourceColName: a,c,d,b

TableColName : a,b,c,d

sourceColName variable contains Column names of source data file which feeds hana tables.

TableColName variable contains Column names of hana tables.

I want to compare above 2 variables to make sure both match.

Is there any function in hana sql to use to compare two variables