sql server upper case to title case code example

Example: how to write uppercase in sql

SELECT UPPER(FIRST_NAME) , LOWER(LAST_NAME)
FROM CUSTOMERS ;