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