is there an easy, automated way to change the case of a
field in every record across the database so that it is
changed from whatever it is (ALL CAPS, Title Case, mIXeD
cASe) into Title Case? This is a Name field, and it
should be Firstname Lastname, but there are also
exceptions to that, like suffixes and titles, etc., that
we don't want to lose. Uniformity is what we seek - even
if AleX REeger and SONS is changed to Alex Reeger and
Sons, that's fine.

I know this sounds like a dopey question. Hopefully one of
you will take pity on an aging hippie (taxpaying, non-tree-
hugging variety, who bathes regularly) and hook me up with
a clue? Many thanks.

Davy with the Wavy Gravy,

No. In a record you would have to loop through the characters looking for
the first after a space and make it upper and the rest lower case. You would
have to take care of exceptions such as MaryAnn, Rogers-Prince, etc.
Enveloping the code into a function would be a convenient way to use it.

Ilya

"Davy with the Wavy Gravy" <anonymous (AT) discussions (DOT) microsoft.com> wrote in
message news:511601c480c9$97b1a4c0$a301280a (AT) phx (DOT) gbl...