I have a query like this:

select * from table1 where field1=:param1 and field2=:param2 and .... and
fieldN=:paramN

While the SQL text takes into account all the possible filters, very seldom
I need to use them all.

I wonder what happens if some parameters are left NULL.

Will the query still work w/o taking into account the NULL parameters ?

Thank you

Duilio Foschi