3 Replies Latest reply: Aug 8, 2014 4:06 AM by Mark Munich RSS

    Wildcard match with 'like'

    Mark Munich

      Hi Community,



      Can i Use Like with Wildcard where i do not speciy any characters but just Wildcard match Format



      example :








      From Table1 Where Field1 like '?????-????-*' ;


      in the above example the the Patterns which i Need to load must be something like  ghfds-fdsd-sdds or dsasdf-fgds-sd


      The table contains more than 50000 rows. this Special pattern which has 5 characters in the begining and then a '-' 4 characters and then '-' and followed by any characters. This pattern indicates a product category. so i want to load this pattern.