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

Akiii
Posted by Akiii under Sql Server category on | Points: 40 | Views : 1604
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

Comments or Responses

Login to post response