sql服务器使大写字母或小写字母

本文介绍了sql服务器使大写字母或小写字母的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我在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 ?

推荐答案

我希望您可以从找到 www.sql-server-performance/forum/threads/initcap -function.3920/ [ ^ ] i hope you find from www.sql-server-performance/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