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.
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.
Assistance with UCase and person surmanes
0 commentaires:
Enregistrer un commentaire