If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
help with finding lowercase characters in table
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. |
#2
|
|||
|
|||
help with finding lowercase characters in table
Hi Joe_G,
You can create a query for this Select LastName, LCase(LaseName) as LCLaseName, Strcomp(LastName, LCLaseName, 0) as CompareWord From [Table] 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 wrote: 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. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...eries/200911/1 |
#3
|
|||
|
|||
help with finding lowercase characters in table
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 Benjamins via AccessMonster.com wrote: Hi Joe_G, You can create a query for this Select LastName, LCase(LaseName) as LCLaseName, Strcomp(LastName, LCLaseName, 0) as CompareWord From [Table] 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 wrote: 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. |
#4
|
|||
|
|||
help with finding lowercase characters in table
On Nov 25, 8:29*am, John Spencer wrote:
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 Benjamins via AccessMonster.com wrote: Hi Joe_G, You can create a query for this Select LastName, LCase(LaseName) as LCLaseName, Strcomp(LastName, LCLaseName, 0) as CompareWord From [Table] 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 wrote: 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..- Hide quoted text - - Show quoted text - Hi, Thank you for the reply; I will try these options out thanks, |
Thread Tools | |
Display Modes | |
|
|