eclipse - BIRT computed column use operator LIKE -

How to use operators in BIRT computed columns?

I tried:

  if (line ["department"] == "% desc%") {'test1'} and {'test2'}  

but it does not work. I have an error (line ["department"] such as "% desc%") {'test1'} and {'test2'}

Message is - [row: 1, column: 28] missing)

---

for example in crystal reports I use

  If {department} is like ["* ​​desc *", "* desc1 *"] then 'test1' and 'test2'  

but support of the BIRT operator does not do. Thank you in advance

as SQL syntax, while expression syntax for a calculated column is javascript. But when you can get the same result with pure SQL, why are you using a compute column? As with Oracle, the following SQL expression is the equivalent:

  The case when 'DEP%' is like DEPT, then 'test1' and 'test2' end  

OTOH If you insist on using a calculation column, you can use regular expressions.