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:
Table:
LOAD
1 as Counter,
Name
From file.txt (txt, codepage is 1252, embedded labels, delimiter is ',', msq)
WHERE Name <> '*coach*';