[AccessD] (OT) Propercase update for last names

Oleg,
Von is not always capitilized. I don't know of any rule but quite often it
is all lowercase. For my ProperCase function I use a lookup table for
exceptions and have a edit form for the totally unusual situations.

HTH
John B.
WinHaven LLC
:o)

> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of
> Oleg_123 at xuppa.com
> Sent: Tuesday, October 14, 2003 11:41 AM
> To: accessd at databaseadvisors.com
> Subject: [AccessD] (OT) Propercase update for last names
>
>
> Hey Group,
> I run a propercase update for last names excluding following formats
> McDonald, MacDonald (second or third letter after Mc or Mac respectively)
> O'Hara, (first letter after apostrophe if first letter in word is "O")
>
>  (I am not sure whats the case with d' like D'Umberville)
> I think Von is always capital, la is always lowercase, and "de" varies. Am
> I missing anything ?
>
>
> -----------------------------------------
> Get Breaking News from CNN, ABC, NBC, CBS Now.
> http://www.xuppa.com/news/?link=webmail
>
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>