lower and uppercaps search (1 Viewer)

Micron

AWF VIP
Local time
Today, 04:45
Joined
Oct 20, 2018
Messages
3,476
No it won't, because the expression only finds capital letters. Upper is just an alias name for the calculated field. To get lower case, you'd need a separate query for Between 97 And 122 or you could try Not Between 65 And 90. I think I'd go with the latter since the only characters that can be upper case are letters from A to Z (assuming this is about English). If you specify 97 to 122 (a to z) you'll omit anything where the value might end in something else, assuming that's even possible.
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 16:45
Joined
May 7, 2009
Messages
19,170
aside from changing "As [Lower] …"
you also need to change the Where clause:

WHERE (((Asc(Right(Nz(fld2,","),1))) Between 97 And 122));
 

Micron

AWF VIP
Local time
Today, 04:45
Joined
Oct 20, 2018
Messages
3,476
Between 97 And 122
Something wrong with the way I said that?
As I said, that will also eliminate anything that might end in a character that's not from a to z, such as %. "Not Between 65 And 90" won't but will eliminate A to Z which is better, IMO.
 

Users who are viewing this thread

Top Bottom