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:258442 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4