I am trying to find a specific row in a table, but i am limited to only searching a small set of data (rather than searching the entire table). So i was thinking about searching where 'date' is between 'date1' and 'date2.' But then I am not sure how to also search for a specific row. For example, I want to get the row that contains order number= 456.