You could use the LCase function. Although it will convert the text to all lower case, I think you could use it in conjunction with the replace function, making sure that it ignores the first letter of the string and converting the rest. ----- Original Message ----- From: "Earl, George" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, May 27, 2003 12:53 PM 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 This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
