WHERE condition

[#1]

Hi,

I have two field values 'Exception' and 'Review'. How can I use these two field values in WHERE condition

like

Where Name='Exception','Review' but it's showing error.

could anyone help me.

thanks

[#2]

Try this:

Where

  (Name = 'Exception') or

  (Name = 'Review');

Regards,

Gerrit

[MayilVahanan · Accepted solution]

HI

Try like this

Where match(Name,'Exception','Review' );

[CELAMBARASAN]

Use Match

Where Match(Name,'Exception','Review')

Hope this helps

[#5]

Thanks very much

[#6]

Thanks