Skip to Content
0

Pass list of values in Contains Functions in Hana

Mar 08, 2017 at 08:35 PM

44

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers