Hi Tim,

Yes I did wonder about your first response :-)

>> In your SP write
>> EXECUTE STATEMENT :my_var_containing_SQL.

Isnt that the same as just running a normal query at the client end ?

I cant seem to see the difference.

How does one get at the result set using the EXECUTE STATEMENT
:my_var_containing_SQL ?

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