help with finding lowercase characters in table


J

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.
 
Ad

Advertisements

J

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

joe_G said:
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.
 
Ad

Advertisements

J

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,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top