If you're only expecting a single record back, can use an approach like the following. Will get you the available rate that equals the desired rate or the next highest.

SELECT TOP(1) *
FROM AvailableRatesTable
WHERE 1=1
    AND State = @State
    AND Rate >= [Desired Rate]

ORDER BY
    Rate