SQL Server Syntax for Lowercase

SELECT LOWER(col_name) FROM tbl_name;