How do you use Or operator like in and not it

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Transact-SQL (2008)

How do you use Or operator like in and not it

Author

Topic

cplusplus
Aged Yak Warrior

567 Posts

Posted - 2011-02-09 : 11:01:49

When i have multiple and conditions i can use in, this way:

WHERE People.Name in ('Jeff','Bill','Pete','Eddy','John Doe','Mike')

Using not in

WHERE People.Name not in ('Jeff','Bill','Pete','Eddy','John')

How can i use 'OR' operator similar to the above:
where Myorderhistory Or('AD345','TRY234',JACOBS32')

Thank you very much for the helpful info.

MIK_2008
Master Smack Fu Yak Hacker

1054 Posts

Posted - 2011-02-09 : 11:27:14

WHERE People.Name in ('Jeff','Bill','Pete','Eddy','John Doe','Mike')
this is not performing AND

Rather its a form of OR and can be rewritten as

Where
(people.name ='Jeff' OR
people.name ='Bill' OR
people.name ='pate' OR
people.name ='abc' OR
people.name ='xyz')