What DB are you using? Oracle8i has a neat function named initcap that will
do it for you. You could say:
SELECT INITCAP(LOWER(city)) as city FROM someTable...
+-----------------------------------------------+
Bryan Love
Database Analyst
Macromedia Certified Professional
Internet Application Developer
TeleCommunication Systems
[EMAIL PROTECTED]
+-----------------------------------------------+
"...'If there must be trouble, let it be in my day, that my child may have
peace'..."
- Thomas Paine, The American Crisis
"Let's Roll"
- Todd Beamer, Flight 93
-----Original Message-----
From: Earl, George [mailto:[EMAIL PROTECTED]
Sent: Tuesday, May 27, 2003 10:54 AM
To: CF-Talk
Subject: Leave first letter uppercase . . .
Is there an existing function or tag that can take an all upper case phrase
and convert it so only the first letter in each word remains uppercase and
the rest of each word is lower case? Specifically, we have City and State
information in our database as all uppercase and we want to display the City
with only the first letter capitalized . . . Thanks!
George
[EMAIL PROTECTED]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4
Subscription:
http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community.
http://www.fusionauthority.com/ads.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
