Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi - simple query here for you experts!
I want the exclude data through the load script. I can do it for one value:
WHERE NOT MARKET = 'INTERCOMPANY' ;
this works fine, but if want to exclude multiple then i am trying to use the following:
WHERE NOT MARKET = 'INTERCOMPANY' OR 'EXPORT';
But this doesnt work - do you know what the right syntax is?
Just 'EXPORT' will not return a Boolean or equivalent representation, I believe.
Try
where not (MARKET = 'INTERCOMPANY' or MARKET = 'EXPORT');
maybe your could use IN (depending on your database used, like
where not MARKET in ('INTERCOMPANY','EXPORT);
regards,
Stefan
Hi,
You have to use some thing like
WHERE NOT MARKET = Match(MARKET, 'INTERCOMPANY' , 'EXPORT' );
HTH
Rgds
Anand
Just 'EXPORT' will not return a Boolean or equivalent representation, I believe.
Try
where not (MARKET = 'INTERCOMPANY' or MARKET = 'EXPORT');
maybe your could use IN (depending on your database used, like
where not MARKET in ('INTERCOMPANY','EXPORT);
regards,
Stefan
Hi,
you can try this.
WHERE (MARKET <>'INTERCOMPANY') AND (MARKET <>'EXPORT')
regards,
Marco
Thanks - they were all helpfull responses but swuehi is the winner