Multiple Wildcards in Query

[PWD]

Good afternoon, Is there a way to have multiple wildcards in a query without having to have multiple "Matches Pattern"? For example if we have various departments that are sub-divisions of F8 or G8 or H8, my colleague wants to be able to use one filter instead of 3.

Many thanks,
D€$

 

[SkipVought]

Hi

F8, G8 & H8???

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[PWD]

Hi Skip, thanks for the response. I've done some more digging and it seems as if it has to be like this:

Matches Patter Value1%

OR

Matches Pattern Value2%

OR

Matches Pattern Value3%



Many thanks,
D€$

 

[SkipVought]

WHAT field is like those 3 values?

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[SkipVought]

This could be...

Where YourField like 'Value1%' 
   Or YourField like 'value2%'
   Or YourField like 'value3%'

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]