Exclude values from a column if they consist of few lists of character in load script

[Reko_freed]

I have a column say 'Department' and they contains values like - 
ab xyz EXT 0098
cd mno INT 887
ef qrs DEV 77
gh uvw EXT 332
ij rst LIQ 21

I just want to add an expression in load script (something like WHERE department NOT IN ('EXT' & 'INT') which will exclude the values which has EXT and INT in them, so my output will be - 
ef qrs DEV 77
ij rst LIQ 21

[mdmukramali · Accepted solution]

Dear @Reko_freed ,

can you try where condition with wild match function like below

Where NOT WildMatch(Data,'*EXT*','*INT*') ;

[Or]

Assuming this is a load script rather than an SQL statement, perhaps:

Where Not WildMatch(Department,'*EXT*','*INT*')

[Reko_freed]

Here what should I put in place of data, is it the column name?

[mdmukramali]

yes, column name.

Department

[Reko_freed]

Many Thanks, @mdmukramali