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 firstname.lastname@example.org
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.