Exclude data from load

[#1]

I cannot figure out how to exclude names containing 'coach'.
 Demographic:
LOAD 
     1 as Counter, 
     LEGAL_NAME
FROM Census.txt
(txt, codepage is 1252, embedded labels, delimiter is ',', msq)
WHERE LEGAL_NAME <> '*coach*';

[#2]

Thanks for all the help.