Query Based on the partial contents of a name....

[Jim Sharky]

.....hope someone can help with this....i'm guessing it's probably pretty
easy.

I have a field whose contents read like so: Mon-WkC-DrvX

What I need to do is find any record whose field contents contain the WkC
portion of the entry above.

I've been trying to create the correct search criteria in my query but I'm
just having a hard time with the correct syntax (and wildcards).

PLEASE HELP! I know it's probably very simple but I'm having mental block!

(e-mail address removed)

 

[Randi]

Use Like "*Wkc*" as the criteria