access - trying to set criteria to equal to "v" but not "V"

G

Gabriele

i am trying to select records with lower case "v" in a particular field but
is also returns capital "V"
 
D

Dale Fye

Take a look at the strComp( ) function.

Field: strComp([FieldName], "v", 0)
Criteria: 0

If the letter "v" you are looking for is a substring in the field, like
"abcv123" then this will not work.

If this is the case, I'd write a little function that I pass the field name
and the character to, and have the function do a character by character
comparison.

--
HTH
Dale

Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.
 
K

KARL DEWEY

This is one way --
Expr2: Asc(Mid([YourField],InStr([YourField],"G"),1))
with criteria 86 as that is the ASCII code for 'V'.
 
Top