Quick suggestion for the SQL part of your problem

😎

USE TEEST;

GO

SET NOCOUNT ON;

DECLARE @SEEK_PRICE INT = 12

;WITH SAMPLE_DATA (ProdName,MinPrc,MaxPrc) AS

(

SELECT 'Apple' , 10, 15 UNION ALL

SELECT 'Orange', 10, 20 UNION ALL

SELECT 'grapes', 12, 30

)

SELECT

SD.ProdName

,SD.MinPrc

,SD.MaxPrc

FROM SAMPLE_DATA SD

WHERE @SEEK_PRICE BETWEEN SD.MinPrc AND SD.MaxPrc;

Output

ProdName MinPrc MaxPrc

-------- ----------- -----------

Apple 10 15

Orange 10 20

grapes 12 30