Exclude data in script

[#1]

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*';