Select where Value is between 2 Column Values ??

[Connatic]

I am having a problem with a query, and because it is Monday morning i don't think my Brain is quite working properly yet, so maybe some one can help me out ?

I have a table in which i have 2 Columns (see below)

Start No / End No
__________________
1! 200 ! 300
2! 400 ! 500
3! 600 ! 700
4! 800 ! 900
------------------

If for instance i have a Value of 350, i need to find out if that number is Between any of the Start / End No's above ?

In this case 350 would be between 400 & 500, and so i would want the Query to select Row 2 !

Any help Appriecated !!

 

[Connatic]

Doh!,

I really was asleep this morning, couldn't think SQL, now with brain fully functioning, i have easily done this Query myself using the BETWEEN function!

-Richard