hi all,

i want to speed up the following SQL Statement with the Contains statement.

-----------------
Select XMLElement("dataarray",XMLAGG(XMLElement("dataarra y", tg.data,
(Select XMLElement("dataarray", XMLAGG(XMLElement("dataarray", p.data)))
From Product p
Where extractValue(p.data,'product/targetid') = to_char(tg.id)))))
From target tg
-----------------

Does anybody know how to do this query with a Contains statement?

thanks
Chris