在sql server中组合列 [英] combine columns in sql server
本文介绍了在sql server中组合列的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
Hi Frnds,
如何组合列。我在注册表中有FirstName,MiddleName,LastName。我使用此查询
选择FirstName +''''+ MiddleName +来自RegistrationTable的''''+ LastName ...
这里中间名也是空的。在那个时候选择查询显示空值,如果名字和姓也存在。那时我使用了ISNULL(MiddleName,''''),但是当时在FirstName和LastName之间不应该显示两个空格。
解决方案
尝试:
SELECT RTRIM(FirstName + ' < span class =code-string>' + ISNULL(MiddleName,' ') )+ ' ' + LastName FROM RegistrationTable
Hi Frnds,
How to combine columns.I have FirstName,MiddleName,LastName in Registration Form.I Used this Query
select FirstName+'' ''+MiddleName+'' ''+LastName from RegistrationTable ...
Here Middle Name is Null Also.At that time Select Query showing null value if First and Last Name Present Also.At that time i used ISNULL(MiddleName,''''),but at that time two spaces should not show in between FirstName and LastName.
解决方案
Try:
SELECT RTRIM(FirstName + ' ' + ISNULL(MiddleName, '')) + ' ' + LastName FROM RegistrationTable
这篇关于在sql server中组合列的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文