The Seybold Report on Internet Publishing
Special to XML.com

Example: Searching on a Column & Text in XML Sections

SELECT	SUM (Amount)
	FROM	Claim_Header ch,
		Claim_Settlements cs,
		Claim_Settlement_Payments csp
WHERE csp.Approver = 'JCOX'
	AND CONTAINS (DamageReport, 'Arson WITHIN motive') > 0
AND CONTAINS (DamageReport, 'Fire WITHIN Cause' ) > 0
AND . . . /* Join Clauses */

Oracle gives as an example, the query, "How much money has Jim Cox approved to date in settlement payments for arson-related fire claims?"