How to write multiple where conditions in single table?

[daisy1438]

I have two requirements below.

1)in my table one of the field data like below

DATA:          require output:

Uk                 Uk
US                 Us

-                   India

-

India

-missing-

-missing-

123

134

when loading time remove '-' and '123' and '-Missing'.

same time i need to write where date>='01/01/208'.

already i am using where <>missing condtion it working.but its remove only -missing-.i need to remove -,123,-missing.and where time>='01/01/2018'

[Anil_Babu_Samineni]

May be use And Operator to work more than one condition like?

Load * From Table Where Not Match(Date, '-missing-', '-', '123') and time >= '01/01/2018';

[shiveshsingh]

You can use where not match('Field Name','Value1','Value2')