You can just use the PHP function ucwords(strtolower()) on the results as you loop through them to create the Select list ;-)

So, this would convert NA to Na, and MG to Mg (as well as mG to Mg and MG to Mg ;-)

Cheers - Neil

At 10:41 01/06/2004 +0000, you wrote:
Date: Tue, 01 Jun 2004 12:41:11 +0200
From: Torsten Lange <[EMAIL PROTECTED]>
Message-id: <[EMAIL PROTECTED]>
MIME-version: 1.0
Content-type: text/plain; charset=us-ascii; format=flowed
Content-transfer-encoding: 7BIT
Subject: big/small letters with oracle No2

> But when using queries on the USER_... data dictionary, Oracle delivers always big letters, which is for
> chemical elements (NA vs. Na) or location names (ALICE SPRINGS vs. Alice Springs) and location codes
> often uncomfortable to read.

It happend in the heat of the moment... The above is only the case for column names, i.e. the parameter columns (Na, Mg...). Locations etc. belonging of course to data sets.


CaptionKit : Production tools
for accessible subtitled internet media, transcripts
and searchable video. Supports Real Player, Quicktime
and Windows Media Player.

VideoChat with friends online, get Freshly Toasted every
day at : NetMeeting solutions
for a connected world.

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to