Results 1 to 2 of 2

Thread: Changine Case

  1. #1
    Join Date
    Apr 2002
    Posts
    14

    Unanswered: Changine Case

    In a table filled with thousands of last names and first names in upper case, how can I get the table to display the names in proper case?

    i.e.
    JOHNSON to Johnson

    JONES DIAZ to Jones Diaz

  2. #2
    Join Date
    Nov 2001
    Posts
    336
    Hi,

    At first, try to find Apel's post here on DBforums. He posted code for the UDF function Proper()
    Then write a query:

    Select Proper(FirstName) as FName, Proper(LastName) as LName, ... From tblMyTable Where ... ;

    HTH, Igor

Posting Permissions

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