Replacement for IN 1

[Mike555]

I'm using a WHERE clause in a stored procedure like the one illustrated below. In this example the effected records are the records where the OrderID = 1,2,3,4,5.

WHERE (ID = @ID) AND (OrderID IN (1,2,3,4,5))

I'm trying to figure out how I can specify a range of numbers instead of identifying each one individually. I'd like to do something like...

WHERE (ID = @ID) AND (OrderID IN (1-5))

Obviously I know I can't use the IN statement to accomplish this. But could someone give me an idea of how I could specify a range? Thanks.


--
Mike

 

[vongrunt]

WHERE (ID = @ID) AND (OrderID BETWEEN 1 AND 5)

 

[MatthewPeters]

WHERE (ID = @ID) AND (OrderID >=1 and OrderID <= 5)

 

[Mike555]

Thank you both for your help. Vongrunt got the star since I had it implemented and tested seconds before mdp's post.

Thanks again!

--
Mike

 

[ESquared]

Just note that on some versions of SQL (not MS SQL Server), the between operator is not inclusive for both operands.

-------------------------------------
It is better to have honor than a good reputation.
(Reputation is what other people think about you. Honor is what you know about yourself.)