I'd like to know if an SQL command exists that will let one find all records that contain a specified string in a specified field/column.
For example, assume that we have a list of publications. I'd like to know if it's possible in an MS-Access query to find all publications that have the string 'World' in their name (e.g. - Worldwide Zookeepers, World Zoos, Zoos of the World). Ideally case-insensitively.
I've been trying the LIKE command, but either I'm using it incorrectly, or it doesn't provide this functionality.