Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Boston, Mass. USA

    Unanswered: function to changing ALL CAPS to A Better Way

    I receive data which I upload into a database which often comes ALL CAPS WHICH IS HARD TO READ AND DOESN'T LOOK NICE.

    Is there a function where I can format this into so the only capital letter is the
    First letter of a text string or
    The First Letter Of Each Word?



  2. #2
    Join Date
    Mar 2003
    The Bottom of The Barrel
    Provided Answers: 1
    Assuming yourField had a value of 'TEST UPPER CASE STRING." This would return "Test upper case string."

    SELECT UCase(Left(yourfield), 1)) + LCASE(RIGHT(yourField, LEN(yourField) - 1)) AS NewString;

    Provided the string is always all caps, you could omit the first UCASE and simplify the query to:

    SELECT Left(yourfield, 1) + LCASE(RIGHT(yourField, LEN(yourField) - 1)) AS NewString;

  3. #3
    Join Date
    Jan 2004
    Try using the strconv function - allows you to change text to Proper Case where the first letter of each word is capitalised.

Posting Permissions

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