Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
try,
load *
From Table
where not wildmatch(Zip_codes,'8*')
Load
Zip_codes
From <> Where Not WildMatch(Zip_codes, '8*');
load * inline [
Zip_codes
500012
500001
500018
500002
800001
800015
]
Where
not WildMatch(Zip_codes, '8*')
;
or
Where
not Zip_codes like '8*';
Thank you