You can do something like <cfset variables.elementLength = len(State);<!--- the Length of your State Name or City Name ---> <cfoutput>#ucase(left(State, 1))# & #lcase(right(State, variables elementLength - 1))#</cfoutput>
Ben -------Original Message------- From: [EMAIL PROTECTED] Date: Tuesday, May 27, 2003 02:07:49 PM 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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4

