I forgot to say..

in real applications i use this logic as

...
and
(:t1 is null or text1 = :t1) -- work if :t1 has value for searching
and
...

Ali