Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2012
    Posts
    4

    Unanswered: SQL SELECT Statement

    I need to change the letter case from a T-SQL SELECT OUTPUT.
    I am Selecting FIRST NAME, LAST NAME and EMAIL ADDRESS.
    The output I get back, for example is:
    MIKE SMITH MSmith@email.com

    I need to have it displayed as Proper case for Name and lower case for email, for example:
    Mike Smith msmith@email.com

    In Excel I can accomplish this with using =PROPER and =LOWER
    However, I need to do this in SQL (Output only)
    I can't change the data as it is stored in the database.
    I have read about stored procs where you can change it in the database
    but I haven't found a method to do it in the SELECT Output. Any ideas? Thanks.

  2. #2
    Join Date
    Aug 2004
    Location
    Dallas, Texas
    Posts
    831
    UCASE = Upper, LCASE = Lower

  3. #3
    Join Date
    Sep 2011
    Location
    Greenville, SC USA
    Posts
    34
    Consider the following for Proper case:
    Less Than Dot - Blog - SQL Server Proper Case Function

Posting Permissions

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