[Openroad-users] Upper/LowerCase

[John Bateson]

Stephen,
While we found a number of years ago it was easy in OR just to take the 
first letter as uppercase and make the rest lower case, and even to handle 
some exceptions, unless you have somebody to go through the database 
manually and adjust all the exceptions - and we had an international list of 
names, then you will create more errors than you might wish to have.
I offer the following as examples of not doing a manual walk through.
    Ludwig Von beethoven or Ludwig von Beethoven
    James d'Ath or James D'ath or James D'Ath
    Ieuan Ap Gruffydds or Ieuan ap Gruffydds
    Piers Ffortescue-Smythe or Piers fFortescue-smythe or Piers 
Ffortescue-smythe or ...

And don't get me started on what is the global version of the UK conception 
of first name and what is last name! As I said we had an international list 
of names.


In the end we left it alone!
John
John Bateson
Buckley
Flintshire
CH7 2QQ
----- Original Message ----- 
From: <stephen.mcculloch at falkirk.gov.uk>
To: "OpenROAD Users" <openroad-users at peerlessit.com>
Sent: Thursday, June 28, 2007 8:58 AM
Subject: [Openroad-users] Upper/LowerCase


> Hi All
>
> Is there a function in OR4.1 sp3 that can convert UPPERCASE to
> UPPER/lower case mix. I would like to output name and address
> details in this format from data stored as uppercase in the database.
>
> example: STEPHEN MCCULLOCH to Stephen MCCulloch.
>
> Thanks
>
> Stephen B McCulloch
> Software Developer
> ----------------------------
> Corporate & Commercial Services
> ICT Infrastructure
> Falkirk Council,
> Municipal Buildings,
> West Bridge Street,
> Falkirk, FK1 5RS
> Scotland, UK
> ------------------------------------------
> Telephone : (01324) 501523
> Fax          : (01324) 501516
> E-mail      : stephen.mcculloch at falkirk.gov.uk
>
>
>
>
>
> The HELIX is an ambitious project to transform the landscape between 
> Falkirk and Grangemouth into a thriving environmental community.
> Project partners are Falkirk Council, Central Scotland Forest Trust and 
> British Waterways.
>
> The HELIX is competing for Big Lottery Funding, and if successful, could 
> win 25 million pounds.
>
> Support the HELIX at www.falkirkonline.net/HELIX
>
> **************************************************************************
> The information contained in this e-mail is confidential and is intended 
> only for the named recipient(s). If you are not the intended recipient, 
> you must not copy, distribute or take any action or reliance on it. If you 
> have received this e-mail in error, please notify the sender. Any 
> unauthorised disclosure of the information contained in this e-mail is 
> strictly prohibited.
>
> The views and opinions expressed in this e-mail are the senders own and do 
> not necessarily represent the views and opinions of Falkirk Council.
> **************************************************************************
>
> ________________________________________________________________
> OpenROAD-Users mailing list
>
> You can maintain your subscription here:
> http://www.peerlessit.com/mailman/listinfo/openroad-users
>
> To unsubscribe click on this link
> mailto:openroad-users-unsubscribe at peerlessit.com&subject=unsubscribe
>
> To subscribe click on this link
> mailto:openroad-users-subscribe at peerlessit.com&subject=subscribe
>