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 :

       

       

      Load

       

      field1,

      field2

       

      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.

       

       

      thanks

       

      Mark