Match

[#1]

Hi,

How can I interptrete below from Qlikview to SQL

MATCH([Order No], '1','2','7','15','16','21') = 0

[jonathandienst]

Match NOT IN ('1','2','7','15','16','21')

[#3]

I would like to write this on SQL, thanks Jonathan

[its_anandrjs]

Use Like function for this.

[its_anandrjs]

Try like

SELECT *

FROM Source

WHERE [Order No] NOT Like '1' OR '2' OR '7' OR '15' OR '16' OR '21' ;

[its_anandrjs]

Another way try

SELECT *

FROM Source

WHERE [Order No] NOT IN ( '1' ,'2', '7', '15' ,'16', '21');

[ashfaq_haseeb · Accepted solution]

Try below

SELECT *

FROM Source

WHERE [Order No] NOT in(1,2,7,15,16,21);

Regards

ASHFAQ

[its_anandrjs]

One of the another way is

SELECT *

FROM Source

WHERE [Order No] NOT Like IN ( '1' OR '2' OR '7' OR '15' OR '16' OR '21' );

Or

SELECT *

FROM Source

WHERE [Order No] NOT Like IN ( 1 OR 2 OR 7 OR 15 OR 16 OR 21 );

Or

SELECT *

FROM Source

WHERE [Order No] NOT Like IN ( 1 , 2 , 7 , 15 , 16 , 21 );