Skip to Content

SAP Hana Web IDE Calculation View filter expressions (LIKE '%SCHMI%')

Hi,

I try to find out, how we have to use the filter expressions, if we want to use i.e. WHERE "NNAMS" LIKE '%SCHMI%'.

Is there a way to do the same within the filter expressions?

("NNAMS"='$$IP_NNAMS$$')

Thanks!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Oct 04, 2017 at 12:05 PM

    I think what you are searching for is the "match" function which you can use in filter expressions.

    For instance (consider that the stars before/after the parameter name are necessary to get the same behavior like you get with % for the like predicate):

    match("NNAMS",'*$$IP_NNAMS$$*')
    Add comment
    10|10000 characters needed characters exceeded