or you could add another table column on to set this new formatted data - depends on you needs
i.e. firstNameDisplay for example and insert formatted data in to that column On 10/30/06, RichL <[EMAIL PROTECTED]> wrote: > run it as it is here if you want to update the current records in the > table with the new value > > On 10/30/06, Dwayne Cole <[EMAIL PROTECTED]> wrote: > > Do I run this as SQL statement or do i run an append query? > > > > > > ---------- Original Message ---------------------------------- > > From: RichL <[EMAIL PROTECTED]> > > Reply-To: cf-talk@houseoffusion.com > > Date: Mon, 30 Oct 2006 16:11:29 +0000 > > > > > > > >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:258448 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
