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
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