sql服务器使大写字母或小写字母 [英] sql server making big letter or low letter

问题描述

我在sql中有FirstName和LastName列.
我要使姓氏"的大写字母大而其余都低.姓氏"的大写字母又大又低.
例如:我们有FisrtName，LastName是john sinatra，我的名字必须是John Sinatra.
T-SQL代码应如何?

I have FirstName and LastName columns in sql..
I want to make First Name''s first letter big and the rests low same LastName''s first letter big and rests low.
For example : we have FisrtName and LastName is john sinatra name mine must be John Sinatra.
How T-SQL code should be ?

推荐答案

我希望您可以从
找到 http://www.sql-server-performance.com/forum/threads/initcap -function.3920/ [ ^ ]

i hope you find from
http://www.sql-server-performance.com/forum/threads/initcap-function.3920/[^]

SELECT
    UPPER(LEFT(FirstName, 1)) + LOWER(RIGHT(FirstName, LEN(FirstName) - 1)),
    UPPER(LEFT(LastName, 1)) + LOWER(RIGHT(LastName, LEN(LastName) - 1))
FROM Employees

这篇关于sql服务器使大写字母或小写字母的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！