Hi
If you mean anywhere in a particular field then if you add something like the following to the criteria box in query designer:
Like "*WhatImLookingFor*"
The key is to a) use the "Like" keyword, and b) surround what you're looking for with * which is the wildcard character.
Hope that helps
Martin