Upper and Lower Case

[Bill]

Hi,

I am trying to find all the list of Lower Case by using query. I have a few lower case that I want to pull it out for a report.

For example:

The list that I have:
f1234......not okay
F3457.....look good
U9832.....look good
yyy23......not okay
ffff56023...not okay

I want to pull the list by query:
f1234
yyy23
ffff56023


Your help would be appreciated.
Thanks

 

[RobFMS]

Bill

Is there a specific reason why you want to find the lower case versus the upper case?
If your intent is to set the lower case to upper case, then you could just easily create a query to go through the entire dataset to up-case the letters. The function you want to use is: UCase().

Additionally, LCase() performs lower case.

HTH

Rob

--
FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Hi,

I am trying to find all the list of Lower Case by using query. I have a few lower case that I want to pull it out for a report.

For example:

The list that I have:
f1234......not okay
F3457.....look good
U9832.....look good
yyy23......not okay
ffff56023...not okay

I want to pull the list by query:
f1234
yyy23
ffff56023


Your help would be appreciated.
Thanks

 

[John Spencer (MVP)]

You could use the Instr function to do a case sensitive compare?

SELECT YourField
FROM YourTable
WHERE Instr(1,UCase(YourField),YourField,0) = 0