How to Remove unused data at script level

[#1]

Hello all, 

Zip_codes
500012
500001
500018
500002
800001
800015

I have data like this, My requirement is i don't want to load the Zip codes starts with '8' at script level. so How can i filter them.

please guide me.

Thanks

Kalyan

[Kushal_Chawda · Accepted solution]

try,

load *

From Table

where not wildmatch(Zip_codes,'8*')

[tresesco]

Load

     Zip_codes

From <> Where Not WildMatch(Zip_codes, '8*');

[maxgro]

load * inline [

Zip_codes

500012

500001

500018

500002

800001

800015

]

Where

     not WildMatch(Zip_codes, '8*')

;

or

Where

     not Zip_codes like '8*';

[#5]

Thank you