SQL Query to get multiple records

Question

Declare @rightId int = 1405; 

SELECT RouteID, @rightId FROM Route

WHERE RouteURI IN

(

'/api/ledger/payment/paymentInfo'

)

for above query i will get one record in result.

 

But my requirement is if i have @rightId = '1405,23.999' 

then i want the three records in result with the above query. 

How to implement query for that ?