Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2002
    Location
    Nottingham - UK
    Posts
    113

    Post Unanswered: Convert text to Small Caps

    I need to convert data in a table that is ALL in UPPER CASE to lower case or Small Caps.

    Can anyone help with the sql to acheive this ?

    Thanks in advance !

  2. #2
    Join Date
    Nov 2001
    Posts
    336
    Try

    Update tblMyTable Set MyField = LCase(MyField);

  3. #3
    Join Date
    Jan 2002
    Location
    Nottingham - UK
    Posts
    113

    Thankyou !

    Worked - saved a lot of time !

Posting Permissions

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