How to use like * with criteria table

[sarab99]

Hi

I am using a table that stored all criteria I need.

I have a query that show result from criteria table.

Iam using "In (SELECT [Field] FROM MyTable)"

But the result shows only exact match.

I want to view result using like "*" to view all result that contain a single word

for example to view all result contain "Hotmail"

Any one can help.

Thanks

 

[sarab99]

I found it

very simple

Like "*" &

![Field]