Skip to Content
avatar image
Former Member

Issue with "CONTAINS OR" query in SAP HANA query

Hi,

I am using HANA query with "CONTAINS OR" for searing the more than one OR condition for like search.

This is my query.

SELECT * FROM table WHERE DELETE_FLAG=0 AND ( CONTAINS(table.NAME,'%Ascendas Magyarorszag Kereskedelmi Korlatolt Felelossegu Tarsasag% OR %Ascendas (MALAYSIA) SDN BHD%')).

If I use that entire input, I could not get the records.But If I reduce the input length like below query, I can get the records. It seems like there is a data length issue on CONTAINS OR query.

SELECT * FROM table WHERE DELETE_FLAG=0 AND ( CONTAINS(table.NAME,'%Ascendas Magyarorszag% OR %Ascendas (MALAYSIA) SDN BHD%')).

How to achieve that CONTAINS OR query for larger input?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers