5 Replies Latest reply on Sep 17, 2019 5:25 AM by Sinisa Mikor

    How to compare 2 column using LIKE in smart reporting 9.1.04

    Sharvan Singh
      Share This:



      We have a requirement to partially compare 2 columns. for this we are creating one calculated field and comparing two columns using Like but its not allowing to save the field. we are receiving Invalid Clause Error. What is the correct syntax to use Like for comparing two columns?


      Have tried below but nothing worked


      CASE WHEN ( Col1 LIKE Col2 ) THEN 'Match' END


      CASE WHEN ( Col1 LIKE ( '%' + Col2 + '%' ) ) THEN 'Match' END