Exclude values in SQL query

[#1]

So i have the below section in my script, as I am trying to exclude Firms with the name ICAP in. But my wildmatch function doesn't seem to work. Is wildmatch the best way of doing this?

SQL SELECT Id,

  AccountId,

  Firm__c

FROM Contact

WHERE AccountId != NULL AND WILDMATCH(Firm__c, '*ICAP*')=0;

I have also tried this, which also does not work

SQL SELECT Id,

  AccountId,

  Firm__c

FROM Contact

WHERE AccountId != NULL AND NOT WILDMATCH(Firm__c, '*ICAP*');

What am I doing wrong?

[pokassov]

Hello!

Wildmatch is QV's operator, not SQL.

Try this

load

     *

where wildmatch(...);

sql select ...;

[swuehl]

Try

SQL SELECT Id,

  AccountId,

  Firm__c

FROM Contact

WHERE AccountId != NULL Firm__c NOT LIKE '%ICAP%';

[alexandros17]

Wildmatch is a qlik function so you cannot use into a Select statement.

You could do

Load

...

Where WILDMATCH(Firm__c, '*ICAP*')=0;

Select

... (Your query)

otherwiseyou can use only SQL

doing:

SELECT Id,

  AccountId,

  Firm__c

FROM Contact

WHERE AccountId != NULL AND not Firm__c Like '%ICAP&';

let me know

[#5]

I am loading from Salesforce, so it needs an SQL statement.

The statement works absolutely fine without the wildmatch bit

[PrashantSangle]

Hi,

try

Firm_c not like '%ICAP%'

Regards

[alexandros17]

use this

SELECT Id,

  AccountId,

  Firm__c

FROM Contact

WHERE AccountId != NULL AND not Firm__c Like '%ICAP%'

[#8]

you missed the AND out, but it didn't work anyway

got this error

ERROR at Row:19:Column:40 unexpected token: LIKE

[#9]

What is the SQL equivalent?

[#10]

didn't work

ERROR at Row:19:Column:39 unexpected token: LIKE