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