Determining if parameter is within range of values

I have an interesting problem. I need to determine if a parameter passed to a stored procedure exists between (or equals) two fields in a table. Here is an example. If I have two fields called Number1 and Number2, and for a particular row, Number1 equals 10 and Number2 equals 14, I need to know if the parameter equals 10,11,12,13, or 14. Effectively, all the numbers between Number1 and Number2 are reserved. Any ideas?

Thank you,
Scott Received on Fri Dec 13 2002 - 09:41:56 CST