I use FOR SELECT in some part of the DB but the problem is when I use multiple criteria for example for the same table order  order_date, order_no, etc... then I had to use execute statement to build query for each criteria. According to your advise, do I need to build the SP with FOR SELECT and call it from the client (delphi) with criteria ?