Distinct values from XML using stylesheet

[DJ_Catboy]

Hi,

I have an XML file as below:

<xml>
  <data>
    <row>1</row>
    <item>xxx</item>
  </data>
  <data>
    <row>2</row>
    <item>yyy</item>
  </data>
  <data>
    <row>3</row>
    <item>xxx</item>
  </data>
</xml>

I need to be able to select each of the "item" entries but have a distinct, unique list (i.e. xxx, then yyy) and I am using an xsl:for-each loop:

<xsl:for-each select="/xml/data/row[-- what do I put in here? --]">
-- code
</xsl:for-each>

So if you know SQL, similar to the "select distinct ... " command.

This is a simplified example of my real application - I know that this can be done many other ways but I need to use a for-each.

Hoping somebody can help.....

DJ

[vbNeo]

if you tried looking at the 'if' function of XSLT? might do what you want