Hi Ali,

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

I think I am starting to understand, am I correct in the following
understanding.

if :T1 is null then dont filter using :T1

Which is exactly what I am trying to do.

How do you change this to cope with integers ?

In the integer part I need the following

If Int1 is < 0 then dont filter on it.

--
Regards,
Grant Brown

Product Development Manager
Phone : 02 4229 1185
Mobile : 0412 926 995
Email : grant@...
Web : www.sitedoc.com.au

SiteDoc - Easy to Use - Powerful Results