Find a number between two sets of numbers. 1

[serino]

I need some help in figuring this out. is there a way to input a number for example "51424303" and it would return a Job_ID of 1939706. Can this be done with a query and if so how?

Job_ID Range1 Range2

 

[SkipVought]

Hi,

Welcome to the new Tek-Tips.

Try this SQL where NUM is the number you referred to.

SELECT Job_ID
FROM yourTableName
WHERE Range_1<=NUM AND Range_2>=NUM

 

[serino]

Skip,

Thanks! that worked for me.