Tech Support Guy banner
Status
Not open for further replies.

Access 2000- Change upper case to lower case

6K views 5 replies 2 participants last post by  THoey 
#1 ·
I created a list of companies & phone #'s etc. in access 2000. The letters are upper case. How do I change upper case listings to lower case?
 
#2 ·
Run an UPDATE query using the LOWER() function:

From the help:

LOWER
Converts all uppercase letters in a text string to lowercase letters.

Syntax

LOWER(text)

Text is the text you want to convert to lowercase. Characters in Text that are not letters are not changed.

There is also a PROPER() function that will do the following:

ACME, INC. to Acme, Inc.
 
Status
Not open for further replies.
You have insufficient privileges to reply here.
Top