0 Replies Latest reply: Mar 19, 2013 5:03 PM by Stuart Wenzel RSS

    Exclude data in script

    Stuart Wenzel

      I cannot figure out how to exclude names with 'coach' in them.

      Demographic:

      LOAD

           LEGAL_NAME,
           1 as Counter

      FROM

      Census.txt

      (txt, codepage is 1252, embedded labels, delimiter is ',', msq)

      WHERE LEGAL_NAME <> '*coach*';