help with finding lowercase characters in table

[joe_G]

Hi,

I have table with 5 columns - one of which is Last Name - and I need
to pull all last names that are in lowercase. The table has 10,000
records and the last name field should look like SMITH, but some of
the records are listed as smith. What query can I run in access on the
LAST NAME field to pull only records where the LAST NAME = lowercase.

 

[John Spencer]

Or just run an update query to change every LastName to ALL upper case

UPDATE [YourTable]
SET LastName = UCase(LastName)
WHERE LastName is Not Null


John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

Hi Joe_G,

You can create a query for this

Select LastName, LCase(LaseName) as LCLaseName, Strcomp(LastName, LCLaseName,
0) as CompareWord From

After that you create 1 query to filter the above query where CompareWord =
0. this will allow to display all the name with LowerCase

Hi,

I have table with 5 columns - one of which is Last Name - and I need
to pull all last names that are in lowercase. The table has 10,000
records and the last name field should look like SMITH, but some of
the records are listed as smith. What query can I run in access on the
LAST NAME field to pull only records where the LAST NAME = lowercase.

 

[joe_G]

Or just run an update query to change every LastName to ALL upper case

UPDATE [YourTable]
SET LastName = UCase(LastName)
WHERE LastName is Not Null

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

Hi Joe_G,

You can create a query for this

Select LastName, LCase(LaseName) as LCLaseName, Strcomp(LastName, LCLaseName,
0) as CompareWord From

After that you create 1 query to filter the above query where CompareWord  =
0. this will allow to display all the name with LowerCase

- Show quoted text -

Hi,

Thank you for the reply; I will try these options out

thanks,