Change field from UCase to LCase

  • Thread starter Thread starter Rick Dunmire
  • Start date Start date
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
 
UPDATE yourTable
SET YourField = Left(YourField,1) & LCase(MID(YourField,2))
WHERE YourField is not null
 
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...
 
Back
Top