SQL LCASE() 函数

    LCASE()函数把字段的值转换为小写。

SQL LCASE() 语法

SELECT LCASE(column_name) FROM table_name;

用于SQL Server的语法

SELECT LOWER(column_name) FROM table_name;

演示数据库

示例

SELECT LCASE(name) AS site_title, url
FROM Websites;