Query criteria - the Like operator

[Guest]

I am trying to get records based on text in a Product ID field. In the
select query, in design view, I have criteria as follows: Like "*GAL*". I
am looking for an item that contains the string GAL.

What ends up happening is the operator turns into Alike and it doesn't work.
What is going on here? Why isn't Like a valid operator?


SELECT [Code 10 Production].ItemNum
FROM [Code 10 Production]
WHERE ((([Code 10 Production].ItemNum) ALike "*GAL*"));

 

[Guest]

Like is a valid operator, but Alike is not. What do you mean by "the
operator turns into Alike"?

 

[Gary Walter]

I am trying to get records based on text in a Product ID field. In the
select query, in design view, I have criteria as follows: Like "*GAL*".
I
am looking for an item that contains the string GAL.

What ends up happening is the operator turns into Alike and it doesn't
work.
What is going on here? Why isn't Like a valid operator?


SELECT [Code 10 Production].ItemNum
FROM [Code 10 Production]
WHERE ((([Code 10 Production].ItemNum) ALike "*GAL*"));

It sounds like you apparently have set Options for
SQL Server Compatible Syntax(Ansi92)...

so...

use ALike and "%"

or uncheck it

and use Like and "*"

good luck,

gary

 

[Guest]

When I'm in Design View of a Select Query, I type:

Like "*GAL*"

in the criteria box under the name of the field I want to search.

After typing in the above and moving the cursor, the criteria reads:

ALike "*GAL*"

I didn't type in ALike...I used Like. I'm like totally confused.

Like is a valid operator, but Alike is not. What do you mean by "the
operator turns into Alike"?

I am trying to get records based on text in a Product ID field. In the
select query, in design view, I have criteria as follows: Like "*GAL*". I
am looking for an item that contains the string GAL.

What ends up happening is the operator turns into Alike and it doesn't work.
What is going on here? Why isn't Like a valid operator?


SELECT [Code 10 Production].ItemNum
FROM [Code 10 Production]
WHERE ((([Code 10 Production].ItemNum) ALike "*GAL*"));

 

[Guest]

You are right. I do have that SQL Server Compatible Syntax (ANSI92) option
on. I am dealing with SQL Server tables....does that force me to keep that
option checked?

Thanks....I thought I was losing it.

I am trying to get records based on text in a Product ID field. In the
select query, in design view, I have criteria as follows: Like "*GAL*".
I
am looking for an item that contains the string GAL.

What ends up happening is the operator turns into Alike and it doesn't
work.
What is going on here? Why isn't Like a valid operator?


SELECT [Code 10 Production].ItemNum
FROM [Code 10 Production]
WHERE ((([Code 10 Production].ItemNum) ALike "*GAL*"));

It sounds like you apparently have set Options for
SQL Server Compatible Syntax(Ansi92)...

so...

use ALike and "%"

or uncheck it

and use Like and "*"

good luck,

gary

 

[Gary Walter]

Depends on what you mean by
"dealing with SQL Server tables"

Almost all my projects are mdb's
accessing SQL Server and I don't
check ANSI-92 option.

That may not help you much though...

I might do a search on Google Groups for

Access ANSI-92

and see what some gotchas might be...

sorry,

gary

You are right. I do have that SQL Server Compatible Syntax (ANSI92)
option
on. I am dealing with SQL Server tables....does that force me to keep
that
option checked?

Thanks....I thought I was losing it.

I am trying to get records based on text in a Product ID field. In the
select query, in design view, I have criteria as follows: Like
"*GAL*".
I
am looking for an item that contains the string GAL.

What ends up happening is the operator turns into Alike and it doesn't
work.
What is going on here? Why isn't Like a valid operator?


SELECT [Code 10 Production].ItemNum
FROM [Code 10 Production]
WHERE ((([Code 10 Production].ItemNum) ALike "*GAL*"));

It sounds like you apparently have set Options for
SQL Server Compatible Syntax(Ansi92)...

so...

use ALike and "%"

or uncheck it

and use Like and "*"

good luck,

gary