SQL将值更改为大写或小写 [英] SQL changing a value to upper or lower case

问题描述

如何在sql select语句中使字段全部大写或小写?

How do you make a field in a sql select statement all upper or lower case?

示例:

从人员"中选择名字

如何使名字始终返回大写而同样总是返回小写?

How do I make firstname always return upper case and likewise always return lower case?

推荐答案

SELECT UPPER(firstname) FROM Person

SELECT LOWER(firstname) FROM Person

这篇关于SQL将值更改为大写或小写的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！