Alike operator replacing Like; I don't know why or how to fix

R

rpurosky

I occasionally have a situation when typing criteria that I never saw in
pre-2007 versions of Access. I type in a wildcard criteria such as 3*.
Normally that would get reformatted to Like "3*". However, the quotes
appear, but the Like operator does not. When I type the Like operator in
manually, it reformats to Alike. I don't know what this operator is. It is
not in the Help files. It doesn't ever give me results when the query is
run. Anybody know anything about it and how to switch back? I checked my
dll references and I don't see anything usual there and tomorrow, my Like
operator may be back as it has come back in the past.
 
J

John Spencer

Alike is like that conforms to ANSI 92 standard. You will need to use % and
underscore in place of * and ?.

If pre-2007 versions, you could go to Tools: Options and the Tables/Queries
tab and check SQL Server Compatible Syntax (ANSI 92). If you unchecked it,
you would then use the JET wildcards and Like.



John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Why does query convert "Like" criteria to "ALike" 1
Query criteria - the Like operator 5
Why does the like operator keep changing to alike in my queries? 1
Getting ALike instead of Like 2
Query using Like Operator 2
How to paste this down? 3
Dealing with a Pivot Table (when I don't want to) 0
What does "Alike" in the filter criteria mean? 1

Top