SQL Server SQL IN Operator for Concatenated values

tvokkenx 于 2023-06-04 发布在其他

关注(0)|答案(2)|浏览(123)

ID	News_Code	News_Digits
1	GBX	400
2	NXC	670
3	LBO	880

I have several codes, what I need to check that code are in News_Code & news_Digit section. My code is like this:

'LBX 345','NXC 670'

What I have tried:

SELECT * 
FROM tblNews 
WHERE News_Code IN ('LBX 345', 'NXC 670')` // But here is the problem is not only the news_code we need to consider the News_Digit as well.

sql-server

来源：https://stackoverflow.com/questions/76359590/sql-in-operator-for-concatenated-values

2条答案

按热度按时间

iezvtpos1#

You can concatenate the two columns and then compare:

SELECT * 
FROM tblNews 
WHERE News_Code + ' ' + News_Digits IN ('LBX 345', 'NXC 670')

If News_Digits is not a string data type, you can change that by casting it:

SELECT * 
FROM tblNews 
WHERE News_Code + ' ' + CAST(News_Digits AS VARCHAR(3)) IN ('LBX 345', 'NXC 670')

赞(0）回复(0）举报 2023-06-04

gcxthw6b2#

You can join a VALUES virtual table (or use a real table variable, Table Valued Parameter or temp table)

SELECT n.*
FROM tblNews n
JOIN (VALUES
  ('LBX', 345),
  ('NXC', 670)
) v(News_Code, News_Digits)
  ON v.News_Code = n.News_Code
 AND v.News_Digits = n.News_Digits;

赞(0）回复(0）举报 2023-06-04

我来回答

SQL Server SQL IN Operator for Concatenated values

2条答案

相关问题

热门标签

最新问答