Finding records with a "/" character in a field

  • Thread starter Thread starter rlh
  • Start date Start date
R

rlh

Sorry if this is a dumb question, but I was given this database to
fix and I'm not well versed with Access.

There's a query in which a text field has a criteria of
Like "*['/']*"

It's suppose to only pick up records where there is a "/" character.
However it seems to be picking up records with "'" character.

Am I correct that the the criteria should be
Like "*[/]*"

and that the "[]" means match any character specified within the brackets???

TIA
 
'MGFoster' wrote on 3/13/2009 4:32 PM:
rlh said:
Sorry if this is a dumb question, but I was given this database to
fix and I'm not well versed with Access.

There's a query in which a text field has a criteria of
Like "*['/']*"

It's suppose to only pick up records where there is a "/" character.
However it seems to be picking up records with "'" character.

Am I correct that the the criteria should be
Like "*[/]*"

and that the "[]" means match any character specified within the
brackets???
Click to expand...

You are correct.
Click to expand...

Thank you so much!
 
Sorry if this is a dumb question, but I was given this database to
fix and I'm not well versed with Access.

There's a query in which a text field has a criteria of
Like "*['/']*"

It's suppose to only pick up records where there is a "/" character.
However it seems to be picking up records with "'" character.

Am I correct that the the criteria should be
Like "*[/]*"

and that the "[]" means match any character specified within the brackets???

TIA
Click to expand...

If the field value is like "Just/Find"

This works for me:
Like "*/*"
as does
Like "*[/]*"
as does
Like "*" & "/" & "*"
 
Back
Top