[RESOLVED] Trickish Situation With Data Range Search

[Tobyy]

Hello,
Please i need help with the following situations.
I have a database table named "tabJrecord" which contains ranges of numbers, like as shown below :

Col1	Col2	Col3	Col4
Apple	REF1	6000	6400
Banana	REF2	6500	6800
Orange	REF3	7000	8000

Now, i have a form which accepts a number, i want to be able to search if that number exist in any range of any row in the table.

For example, if a user enters number 6,300. I want to be able search the table rows and my recordset should be able to tell me the number 6,300 exist in for the Fruit "Banana". That is if the number is between Col3 and Col4 of any row.

Kindly help with the MSSQL Query for this.

Thanks.