Update Query

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chris - 28 Apr 2005 18:50 GMT

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)

Reply to this Message

Jason Rice - 28 Apr 2005 19:14 GMT

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

> Hello All.
>
[quoted text clipped - 7 lines]
>
> So I'm looking for a query like UCASE([SName],4)

Reply to this Message

Ed Warren - 28 Apr 2005 21:29 GMT

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 ;)

> Hello All.
>
[quoted text clipped - 7 lines]
>
> So I'm looking for a query like UCASE([SName],4)

Reply to this Message