how to display column value in lower case in sql server

SQL LOWER() function converts all the characters in a string into lowercase.