本文介绍了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
更多推荐
sql服务器使大写字母或小写字母
发布评论