There's a CFC called titlecase.cfc on cflib.org which is usually used for names (i.e recognises von, de as small etc..) You may be able to alter it to suit your needs
T On 22 Nov 2006, at 14:06, Andy Matthews wrote: > You could do a test and cap the first letter of any word 4 letters or > longer. > > <!----------------//------ > andy matthews > web developer > certified advanced coldfusion programmer > ICGLink, Inc. > [EMAIL PROTECTED] > 615.370.1530 x737 > --------------//---------> > > -----Original Message----- > From: RichL [mailto:[EMAIL PROTECTED] > Sent: Wednesday, November 22, 2006 5:03 AM > To: CF-Talk > Subject: Country Name Case > > > Hi Guys > > I have a country reference table where all of the country names are > held in upper case. > > I want to be able to output in lower case but keep the caps where > appropriate (e.g. UNITED KINGDOM to United Kingdom). > > However I think that this going to be close to impossible as there are > values such as: > > VIRGIN ISLANDS (BRITISH) > VIRGIN ISLANDS (U.S.) > WALLIS AND FUTANA > > So using a function to capitalise the first letter of each word won't > really work. > > How have people approached this situation and has anybody found any > good solution? > > Also, is there a UDF around for capitalising the first letter of > each word? > > Thanks in advance > > -- > Rich > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:261389 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4