Access 2002 and LIKE

[Justin Koivisto]

Forgive me if this has been discussed before, but i didn't find anything
that matched at google groups...

I am having a problem selecting records using LIKE and wildcards. I have
a field named "Code" that has values like:
"A"
"A, H"
"C, M, A"
"H, M"

In the query design view, I have the Criteria of the "Code" column as:
Like "*" & [Search Code:] & "*"

So when I run the query, I am propted for the search code, which works
fine. However, the only records selected are the ones that have "A" as
the code. I had expected all records containing "A" in the field,
selecting all above examples except "H, M".

Can someone please tell me what I am missing here?

--
Justin Koivisto - sp**@koivi.com
PHP POSTERS: Please use comp.lang.php for PHP related questions,
alt.php* groups are not recommended.

[Wayne Morgan]

I just tried this and it works as you say you would expect it to. Can you
post the SQL of the query?

--
Wayne Morgan
Microsoft Access MVP
"Justin Koivisto" <sp**@koivi.com> wrote in message
news:a5*****************@news7.onvoy.net...

Forgive me if this has been discussed before, but i didn't find anything
that matched at google groups...

I am having a problem selecting records using LIKE and wildcards. I have
a field named "Code" that has values like:
"A"
"A, H"
"C, M, A"
"H, M"

In the query design view, I have the Criteria of the "Code" column as:
Like "*" & [Search Code:] & "*"

So when I run the query, I am propted for the search code, which works
fine. However, the only records selected are the ones that have "A" as
the code. I had expected all records containing "A" in the field,
selecting all above examples except "H, M".

Can someone please tell me what I am missing here?

[Pavel Romashkin]

In 2002, I think you can't use * at the beginning of the LIKE argument.
If you do, the wildcard is ignored. Take a look in the Help file.

Pavel

Justin Koivisto wrote:

Forgive me if this has been discussed before, but i didn't find anything
that matched at google groups...

I am having a problem selecting records using LIKE and wildcards. I have
a field named "Code" that has values like:
"A"
"A, H"
"C, M, A"
"H, M"

In the query design view, I have the Criteria of the "Code" column as:
Like "*" & [Search Code:] & "*"

So when I run the query, I am propted for the search code, which works
fine. However, the only records selected are the ones that have "A" as
the code. I had expected all records containing "A" in the field,
selecting all above examples except "H, M".

Can someone please tell me what I am missing here?

--
Justin Koivisto - sp**@koivi.com
PHP POSTERS: Please use comp.lang.php for PHP related questions,
alt.php* groups are not recommended.

[Justin Koivisto]

Wayne Morgan wrote:

I just tried this and it works as you say you would expect it to. Can you
post the SQL of the query?

I found the problem. The query was working correctly, but the data for
the record that was missing was corrupt. I imported the data from the
CSV file again, and it's all working as expected... Sorry.

--
Justin Koivisto - sp**@koivi.com
PHP POSTERS: Please use comp.lang.php for PHP related questions,
alt.php* groups are not recommended.

[Justin Koivisto]

Pavel Romashkin wrote:

Justin Koivisto wrote:

Forgive me if this has been discussed before, but i didn't find anything
that matched at google groups...

I am having a problem selecting records using LIKE and wildcards. I have
a field named "Code" that has values like:
"A"
"A, H"
"C, M, A"
"H, M"

In the query design view, I have the Criteria of the "Code" column as:
Like "*" & [Search Code:] & "*"

So when I run the query, I am propted for the search code, which works
fine. However, the only records selected are the ones that have "A" as
the code. I had expected all records containing "A" in the field,
selecting all above examples except "H, M".

Can someone please tell me what I am missing here?

In 2002, I think you can't use * at the beginning of the LIKE argument.
If you do, the wildcard is ignored. Take a look in the Help file.

Pavel

That's incorrect, using the Like "*" & [Search Code:] & "*" syntax, I am
getting the results I had expected. For instance, if I enter M as the
search code, I do get the two records as an example above. Also, in the
help file under a subhead of "Part of a field's value (Like)" it does
show a table where the expression used is Like "*Imports" and the result
is stated as "For a ShipName field, orders shipped to customers whose
names end with the word "Imports" (ANSI-89)".

--
Justin Koivisto - sp**@koivi.com
PHP POSTERS: Please use comp.lang.php for PHP related questions,
alt.php* groups are not recommended.