CONTAINS any of multiple values

Question

CONTAINS any of multiple values

Stavros_McGillicuddy

Old Hand

Points: 331
More actions
January 14, 2021 at 11:47 pm
Go to Answer
#3833590
Sorry for the NUBE question
I need to build a select statement where a column contains any of many possible values
I think I can create multiple lines like this but, I think there is a more efficient way to do it, especially because I have 30 variables
```
select * from COMPANY
where 
contains (PRODUCTS, "Product1")
or
contains (PRODUCTS, "Product2")
or
contains (PRODUCTS, "Product3")
or
contains (PRODUCTS, "Product4");
```
- This topic was modified 4 years, 5 months ago by Stavros_McGillicuddy.
DesNorton

SSC-Insane

Points: 24511
More actions
January 15, 2021 at 5:33 am
Answer
#3833650
This may be what you are looking for .
```
SELECT  *
FROM    COMPANY
WHERE   PRODUCTS IN ( 'Product1', 'Product2', 'Product3', 'Product4' );
```
How to post data/code on a forum to get the best help.

Viewing 7 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

ScottPletcher SSC Guru Points: 101192 More actions · Answer 1

contains (PRODUCTS, 'Product1 OR Product2 OR Product3 OR Product4 OR ...')

SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".

ktflash Default port Points: 1400 More actions · Answer 2

what on earth is contains, ive never seen that used before

mom pick me up im scared

I want to be the very best
Like no one ever was

https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help

Stavros_McGillicuddy Old Hand Points: 331 More actions · Answer 3

Thank you @DesNorton and @ScottPletcher. These both work. Exactly what I was looking for

ratbak Default port Points: 1411 More actions · Answer 4

FULLTEXT indexing/search: https://docs.microsoft.com/en-us/sql/t-sql/queries/contains-transact-sql?view=sql-server-ver15

eduardoalmeidabr Old Hand Points: 350 More actions · Answer 5

lol Me too! But it's got great documentation: https://docs.microsoft.com/en-us/sql/t-sql/queries/contains-transact-sql?view=sql-server-ver15

CONTAINS any of multiple values

Cookies on SQLServerCentral