Update to lowercase

Results 1 to 2 of 2

Thread: Update to lowercase

  1. #1
    J Guest

    Default Update to lowercase

    How can I use SQL to update all forenames in a table so the first letter is upper case and all the rest are in lowercase ?<BR><BR><BR>thank you

  2. #2
    Join Date
    Dec 1969

    Default RE: Update to lowercase

    This should do the trick:<BR><BR>MySql = "Update MyTable SET Forename = Ucase(Left([Forename],1)) & Lcase(Right([Forename],Len([Forename])-1))"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts