4 Replies Latest reply: Aug 29, 2013 5:51 AM by Celambarasan Adhimulam RSS

    Excluding records with symbols

      Hello,

       

      I am loading data from a database but since there is alot of records i want to filter the records that contain a symbol.

       

      The following symbols i want to exclude:

      *, /, #

       

      I tried the following:

       

      [Example]:

      LOAD

           [KeyPart]

      SQL SELECT

      FROM Database

      WHERE [KeyPart] NOT LIKE '*'