[Openroad-users] Upper/LowerCase

[stephen.mcculloch at falkirk.gov.uk]

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.
**************************************************************************