khandaresarang (10/24/2016)

---

Guys,

I have a database contains 3 fields for a Price as:

ProdName , MinPrc and MaxPrc.

Now i want to write a search query for:

When i enter the price in the textbox it should return the product name.

For eg:

ProdName MinPrc MaxPrc

Apple 10 15

Orange 10 20

grapes 12 30

Now i enter a price 12, so output should return all the rows which satisfies the value.

Thank you in advance.