UCASE()函数把字段的值转换为大写。
SQL UCASE() 语法
SELECT UCASE(column_name) FROM table_name;
用于SQL Server的语法
SELECT UPPER(column_name) FROM table_name;
演示数据库
示例
SELECT UCASE(name) AS site_title, url
FROM Websites;
UCASE()函数把字段的值转换为大写。
SQL UCASE() 语法
SELECT UCASE(column_name) FROM table_name;
SELECT UPPER(column_name) FROM table_name;
示例
SELECT UCASE(name) AS site_title, url
FROM Websites;