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

    Omitting certain string descriptions from a field.

      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.






      from ....

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


      Thanks in advance.


      Best Regards,