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: [email protected] > 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:258447 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
