Skip to Content
0
Apr 17, 2018 at 12:29 PM

HANA CONTAINS() predicate with multiple columns and multiple search criteria

1736 Views

Hello,

I want to use contains() predicate with multiple search criteria.

But I have an error message saying: feature not supported: More than one CONTAINS with multiple columns

SELECT * FROM HANA_View
WHERE CONTAINS ( ( WERKS, MATNR, LANDX, MAKTX, NAME1, LAND1, LIFNR, IDNLF ) , '%Search1%') 
AND CONTAINS ( ( WERKS, MATNR, LANDX, MAKTX, NAME1, LAND1, LIFNR, IDNLF ) , '%Search2%') 

Could you please suggest how can I manage this requirement using one contains?