sql Query

How can I rewrite the select statement without using IN


SELECT *
 
FROM dbo.tblcustomers
 
WHERE custstate IN ('CA','MI','WA')

Open in new window

iolikeAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
asitkaushikConnect With a Mentor Commented:
SELECT *
 
FROM dbo.tblcustomerss
 
WHERE (custstate ='CA' )OR (custstate ='MI') OR (custstate ='WA')
 
This can be one of an alternate query
0
 
iolikeAuthor Commented:
Thanks, it worked
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.