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

    Find a specific text in a field

    silviu andries

      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!

      Silviu