Signed StationeryI have had a number of versions of the proper function over
the years.  None have been perfect.

I need to be able to produce the following outcomes

Awaiting Allocation CMHT
Ruud van Nistelroy
Martin O'Neill
Joan Hunter-Dunn
The Mill on the Floss
Dave McKay
Barry Macklin
Jim MacIlvaney


I think what I need is a combination of basic rules and a place to list
words which have certain specific rules attached to them




Steve K
~~~~~~~~~~~~~~~~~~
Steve Klein
tel:         0118 984 5109
mobile   0797 181 5676
~~~~~~~~~~~~~~~~~

We have the same problem.  All the possible variations along with 
individual
preferences (whatever rule you design will have exceptions) make it 
almost
impossible to design a perfect proper function.  The best way to handle 
this
is to store the data in mixed case and to use the UCase() function to
prepare the data for mailings.  The PO prefers upper case.  This is the 
only
way to handle:

MacKenzie vs. Mackenzie
vanGogh vs. Van Gogh
etc.

Rand E. Gerald
Database Specialist
Information Services / Operations
Bah=E1'=ED National Office
1233 Central St.
Evanston, IL  60201
(xxx) xxx-xxxx

-----Original Message-----
From: Steve Klein [mailto:Stephen@K...]
Sent: Thursday, February 13, 2003 07:05
To: Access
Subject: [access] proper

Signed StationeryI have had a number of versions of the proper function 
over
the years.  None have been perfect.

I need to be able to produce the following outcomes

Awaiting Allocation CMHT
Ruud van Nistelroy
Martin O'Neill
Joan Hunter-Dunn
The Mill on the Floss
Dave McKay
Barry Macklin
Jim MacIlvaney


I think what I need is a combination of basic rules and a place to list
words which have certain specific rules attached to them




Steve K
~~~~~~~~~~~~~~~~~~
Steve Klein
tel:         0118 984 5109
mobile   0797 181 5676
~~~~~~~~~~~~~~~~~