2 Replies Latest reply: Mar 2, 2012 12:40 PM by silviu andries RSS

    Find a specific text in a field

      Hello everyone,


      I have to put a condition on a field:


      the sql looks like this:


      upper(pp.name)  like '%PARCHETUL%' OR upper(pp.name)  like '%PREFECT%' OR......



      how can this conditions be implemented into a expression from a table.


      The only functions I have found are: left() right() mid()...but this can't be used...


      Help me please in this small problem.


      Thank you in advance!