Update Query

[Chris]

Hello All.

I have a big list of clients names. The surname was setup so that the first
letter was UCase and the remainder of the name is LCase.

However, We have many 'Mac's' e.g. Maclenan. I would like to change this to
MacLenan with the 4th letter being UCase.

So I'm looking for a query like UCASE([SName],4)

 

[Jason Rice]

You could use something like this:

UCase(Left(SName,1)) & LCase(Mid(SName,2,3)) & UCase(Mid(SName,4,1)) &
LCase(Mid(SName,5,Len(SName)-4))

HTH

Jason Rice

 

[Ed Warren]

Do you want all the Warrens to become WarRens?

In a small sample of surnames I have convienient, I can see the following
problem entries to think about:

Mackey-Sy
Mace
Macurak
Macon
Macias
Mackey
Macholan
Mache


assuming you have a way to 'sort out' all the MacXX's from the Macxx's and
the McXx's etc
Then you can run the query recommended by Jason and it will make the changes
you desire (with modifications for the McXx's

Ed WarRen