Code Snippet posted by:
Akiii | Posted on: 7/9/2012 | Category:
SQL Server Codes | Views: 495 | Status:
[Member] |
Points: 40
|
Alert Moderator
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