6 Replies Latest reply: Nov 14, 2013 4:24 AM by Ram Asokan RSS

    Omitting certain string descriptions from a field.

    Ram Asokan

      Hello there folks,


      I am trying to figure something out here, I would like to remove all descriptions from a field which starts with the character '.' and '-'.


      I have tried the below script but failed badly, could anyone point me in the right direction or advise on what am doing wrong here.


      Table_A:

      Load

      [Country],

      [Date],

      [BrandDesc]

      from ....

      where [BrandDesc] <> '.*' and [BrandDesc] <> '-*';

       

      Thanks in advance.

       

      Best Regards,

      Ram