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

Posted by Akiii under Sql Server category on | Points: 40 | Views : 2097
If you need to convert characters to upper-case/lower-case then you can simple use the below queries :-

SELECT UPPER(ColumnName) FROM TableName;


SELECT LOWER(ColumnName) FROM TableName;

For example :-

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

Thanks and Regards

Comments or Responses

Login to post response