Exclude string of values from load?

[#1]

Hi,

I'm trying to exclude any client where the name is "Trendsight" from my load, but my statement doesn't seem to be working...

LOAD

          ClientName,

FROM

Data\Clients.qvd

(qvd) where ClientAccountName<>WildMatch(ClientAccountName, 'Trendsight.*');

Any thoughts?  The issue is that this client has multiple divisions that we treat as separate clients, so I need a string variable rather than manually excluding each client from the load.

[hic · Accepted solution]

LOAD ClientName,

FROM Data\Clients.qvd (qvd) where not WildMatch(ClientAccountName, 'Trendsight*');

HIC

[#3]

LOAD

ClientName

FROM Data\Clients.qvd (qvd)

where NOT (ClientAccountName like 'Trendsight*')

;

[#4]

Ahhh, that's it.  Worked perfectly, thank you!