There are a few titlecase style UDFs at cflib.org, but the simplest solution is..
str = ucase(left(str,1)) & lcase(right,len(str)-1); ======================================================================== === Raymond Camden, ColdFusion Jedi Master for Mindseye, Inc (www.mindseye.com) Member of Team Macromedia (http://www.macromedia.com/go/teammacromedia) Email : [EMAIL PROTECTED] Blog : www.camdenfamily.com/morpheus/blog Yahoo IM : morpheus "My ally is the Force, and a powerful ally it is." - Yoda > -----Original Message----- > From: Earl, George [mailto:[EMAIL PROTECTED] > Sent: Tuesday, May 27, 2003 11: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
