SQL – SQL Server UPPER() Function
The SQL Server UPPER() function converts a string to upper-case.
The SQL Server USER_NAME() function returns the database username based on the specified id.
The SQL Server YEAR() function returns the year part for a specified date.