Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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*';