>I have developed a prg for calculating interest on Savings Bank Account. It is working fine but very slow.
>I want to know that is it possible to use SQL command when there are many if conditions.
<snip>
Your query will be slow if it cannot be optimized using the indexes on the tables involved in the query.
--sb--