Pass list of values in Contains Functions in Hana

[former_member390478]

Hi

I want to pass some list of values in the contains function instead of one values. The list of values I am selecting from table. Is it possible or Hana is having any different function to get this concept?

Example
SELECT Id, A_Name

FROM A_Table

WHERE CONTAINS (A_Name, (Select B_Name from B_Table), Fuzzy (06, 'similarcalculationmode=search'));

Thanks

R Sanjay