How to remove record from the field

[bhavvibudagam]

Hi Experts,

Can any one please help me on this.

TableA:

Load

Data,

ID,

Country,

State

From ....

In the above table Country field contains 5 countries out of 5 countries I have to remove Japan record from country field and from State I have to remove Tokyo record from 5 states.

The filtering need to be done at only field level in the back end script only not at data level.

Please suggest me to proceed.

Thanks in advance.

[its_anandrjs]

Can you share any sample data.

[its_anandrjs]

May be this you can

TableA:

Load

Data,

ID,

Country,

State

From ....

Where Not Match(Country,'Japan') and Not Match(State,'Tokyo');

[OmarBenSalem]

maybe :

TableA:

Load

Data,

ID,

Country,

State

From .... where Country <>'Japan';