i use execute statment to build SP query and return record depend on params
bu my firend still use that way to take param of SP

for select * from table1
where param1 is null or fld1 = param1
is firebird optimizer igonor the WHERE condition if param1 is null

zaher dirkey