can I filter by case in access filters?

G

gbodie

I am trying to sort a database which contains numerous entries such as "2Ad1
3aAdi" . I am trying to filter by case, e.g. show me all with A*A in them
(but not A*a). I know I can search & replace by case, but can't seem to
filter by case. Why not? Or am I missing something?
 
D

Douglas J. Steele

Access isn't case sensitive by design.

You could try something like

[MyField] Like "A*A" And StrComp([MyField], UCase([MyField]), 0) = 0

Note, though, that it'll be slow.
 
Top