>1. Base command: >Select lastname from People ; > INNER JOIN statushistory on people.peostcfk = statushistory.sthid ; > where people.peoschfk = ?nschfk > >2. Command with multiple paramaters added: >Select lastname from People ; > INNER JOIN statushistory on people.peostcfk = statushistory.sthid ; > where people.peoschfk = ?nschfk ; > and poeple.peolastname >= ?cStartLast ; > amd people.peolastname <= ?cEndLast > >3. Command with different parameters added: >Select lastname from People ; > INNER JOIN statushistory on people.peostcfk = statushistory.sthid ; > where people.peoschfk = ?nschfk ; > and people.peossn = ?nssn >>You can see that the select statement varies significantly from one execution to another. Do you have any suggestions or tips for me on how to manage this in my application?