Lowercase query sort problems

[cayham86]

Hey guys,



I have a set of codes in a database but some of them have been inputted lowercase and not in uppercase, so wondering how do I make a query to display only rows where the codes are lowercase?

Help with example code would be appreciated.

[CJ_London]

crossposted here with quite a few answers https://www.access-programmers.co.uk.../#post-1833796

[cayham86]

That is my post on there but can't use there suggestions as it has to be done via an access query and not SQL plus they are suggesting I should get the program to auto fix them when I can't due to the way the system works

[CJ_London]

queries are sql - and from what you now appear to want cannot be done in the query window

as far as autofix is concerned it was a suggestion since you requirement is unusual.

I don't think I can add anything to what has been suggested on the other forum

[Welshgasman]

Now also crossposted at https://www.mrexcel.com/board/thread...blems.1209462/