Need help using LIKE predicate

arage

Registered User.
Local time
Today, 21:51
Joined
Dec 30, 2000
Messages
537
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(
.[field],"criteria"))<>"0"))
 

Users who are viewing this thread

Back
Top Bottom