Need help using LIKE predicate
My database has story titles, but some titles are special b/c they don't start with letters, some of them include:

'Blue Eyes'
...And My Fear Is Great

I've been trying to specify criteria using the LIKE operator in my query to capture these types, but have come up empty handed. I basically want to show these "special titles" in a special set of results that only show them, but i cannot seem to capture titles that begin with non-alphaNumeric characters like a period or single quotation. What to do?

i'm using ACCESS 97

You can do a search using the LIKE operator by placing all the characters you are looking for inside square brackets. ie:

Like "['@$]*"

This will return any entries that contain an ', @, or $ n the first space. To search for it anywhere in a string, you can change the Like statement to read Like "*['@$]*". Have a look at the topic 'LIKE Operator' in Access Help. It covers all the different types of pattern matches you can perform.

HTH

SteveA

Well, this works....

Like "[!A-Z]*"

thanks though Steve

((InStr([table].[field],"criteria"))<>"0"))