如何将连接的多列值作为搜索条件 [英] How to pass concatenated multiple column value as the search condition
本文介绍了如何将连接的多列值作为搜索条件的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我正在使用SQL Server 2008
我连接了两个值表(Person)的列(名字和姓氏)。我想根据这个名字检索所有的值。
我用过这个查询
SELECT * FROM Person WHERE FirstName + LastName LIKE'[abdulkalam%]';
其中abdul是列Firstname的值,kalam是LastName的值。 />
提前谢谢
解决方案
检查这个...
SELECT * FROM Person 其中 UPPER(RTRIM(LTRIM(FIRSTname)))+ UPPER(RTRIM(LTRIM(LastName)))
赞 UPPER(' abdulkalam%')
希望这会对你有所帮助。
干杯
Hi,
I'm using SQL Server 2008
I have concatenated values of two columns(Firstname and lastname) of a table(Person). I want to retrieve all the values based on this names.
I have used this query
SELECT * FROM Person WHERE FirstName+LastName LIKE '[abdulkalam%]';
where abdul is the value of the column Firstname and kalam is the value of LastName .
Thank you in advance
解决方案
Hi,
Check this ...
SELECT * FROM Person Where UPPER(RTRIM(LTRIM(FIRSTname))) + UPPER(RTRIM(LTRIM(LastName))) Like UPPER('abdulkalam%')
Hope this will help you.
Cheers
这篇关于如何将连接的多列值作为搜索条件的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文