Convert characters to upper-case and lower-case in SQL server

If you need to convert characters to upper-case/lower-case then you can simple use the below queries :-

SELECT UPPER(ColumnName) FROM TableName;

or

SELECT LOWER(ColumnName) FROM TableName;

For example :-

SELECT UPPER(FirstName), LOWER(LastName) FROM EmployeeTable;

Thanks and Regards
Akiii