(of course that won't cater for Mary-Joe etc which would become Mary-joe or Mary Joe which would become Mary joe)
On 10/30/06, RichL <[EMAIL PROTECTED]> wrote: > Dwayne > > Update tblname set firstname = UCase(Left(firstname,1)) &LCASE( > right(firstname,( Len(firstname)-1))) > > Seems to do it ? > > On 10/30/06, Andy Matthews <[EMAIL PROTECTED]> wrote: > > If you have a text editor capable of changing case, then it would probably > > be just as easy to select the whole column, paste it into your text editor, > > changing case all at once, then paste it back in. > > > > I do that sort of thing all the time. > > > > <!----------------//------ > > andy matthews > > web developer > > certified advanced coldfusion programmer > > ICGLink, Inc. > > [EMAIL PROTECTED] > > 615.370.1530 x737 > > --------------//---------> > > > > -----Original Message----- > > From: Dwayne Cole [mailto:[EMAIL PROTECTED] > > Sent: Monday, October 30, 2006 9:55 AM > > To: CF-Talk > > Subject: OT - MS Access UPPERCASE to Lowercase > > > > > > I have a bunch (800) of UPPERCASE names (ie DWAYNE) in an access database > > field that I would like to convert to lower case (from DWAYNE to Dwayne). > > Does anyone know of a function that I can use? > > > > Dwayne > > > > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:258443 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
