Hi Tim,

>> I think you are really looking for is full blown case logic where

parts of the statement can be included depending on some input.

Which is exactly what I am after.

>> ABC.SQL.Add('where Detect= :123);
>> if X = true then ABC.SQL.Add('and Text1= :T1);
>> if C = true then ABC.SQL.Add('and Text2= :T2);

Hence the "if X = true then ABC.SQL.ADD(...." with the ".ADD" part being
the important bit.

But anyway thanks for your help Tim. Given the bad raps I have read
about the Execute Statement a dynamic query at the client side may be
the way to go, however Ali has suggested a way to go so I will try that
first.

Again thanks for your help.

--
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