Assistance with UCase and person surmanes

[plannerg]

I am hoping someone can help me here.

I have peoples surnames that I need to be in all uppercase but for Surnames beginning with MC (i.e. McDonald, McKay etc) I need the 'c' to be lower case so that names display as McDONALD and McKAY. The same foe a few that begin with Le (i.e LeCRAS).

Is someone able to help me achieve this.

The code I'm currently using is:

Name: (UCase([LastName]))+" "+([FirstName])

Thanks.

 

[Galaxiom]

For Mc it could start like this:
IIF(Left(Lastname,2)="mc", "Mc" & UCase(Mid(Surname,3)) ....

Le is a problem because there are names like Lester etc.

 

[plannerg]

....thanks. Any idea how it may finish as well!??

 

[Galaxiom]

Try this:

IIF(Left(Lastname,2)="mc", "Mc" & UCase(Mid(Lastname,3)) & " " & UCase(Firstname), UCase([LastName] & " " & [FirstName]))

If you want to be a successful developer you really need to try and work some stuff out yourself. You replied only five minutes after I posted so you clearly didn't try very hard.

Look at the help for the functions used. It isn't a difficult expression.

 

[Mile-O]

Other name issue.... MacDonald and Macauley.