Change field from UCase to LCase

R

Rick Dunmire

Hello,

I have been looking for a query to change a field from uppercase to
lowercase and then make the first letter in that field UCase. It's a
lastname field and everything in the database is ucase.

Can anyone help with this?

Rick
 
J

John Spencer (MVP)

UPDATE yourTable
SET YourField = Left(YourField,1) & LCase(MID(YourField,2))
WHERE YourField is not null
 
R

Rick Dunmire

Thanks John,

Thats what I needed.

Rick

John Spencer (MVP) said:
UPDATE yourTable
SET YourField = Left(YourField,1) & LCase(MID(YourField,2))
WHERE YourField is not null
Click to expand...
 

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

Similar Threads

to query for proper case text 1
Access to split First and Last name 0
UDF in query of linked table Causes #Error 5
UCase 2
Ucase first character of string 3
Query not limited as expected 4
Changing uppercase to lowercase 4
Update query to change case 1

Top