XSLT/XPath - Find unique text node value

[Raymond Law]

I have the following XML and want to retreive unique text node. Can xPath/XSLT achieve that??
<root>
<Dept>IS</Dept>
<Dept>AD</Dept>
<Dept>IS</Dept>
<Dept>HR</Dept>
<Dept>RD</Dept>
<Dept>HR</Dept>
</root>
Result:
IS
AD
HR
RD

[Steven Broadbent]

You want to retrieve all distinct values?
I think this is possible using axes

[Micheal Jacob]

Hi,
Here is the code. But in this i have faced one problem. The problem is,any axis looks on the original source document, not the logical xml document after ascending.
so this piece of code will fetch the unique values when it is in ascending order.

  
<xsl:stylesheet version = '1.0' xmlns:xsl='http://www.w3.org/1999/XSL/Transform'>
<xsl:template match="root">
<xsl:for-each select="Dept">
   <xsl:sort order="ascending"/>
<xsl:if test=". != following-sibling: :mrgreen: ept[1] or     not(following-sibling: :mrgreen: ept[1])">
   <xsl:value-of select="."/> <br/>
</xsl:if>
</xsl:for-each>
</xsl:template>
</xsl:stylesheet>

This xsl look upon the previous given xml.
Let's wait for others view on this.
Micheal

[Roseanne Zhang]

Here is a much simpler solution:

<?xml version="1.0"?>
<xsl:stylesheet version="1.0" 
  xmlns:xsl="http://www.w3.org/1999/XSL/Transform">
  <xsl:output method="text" />  
  <xsl:template match="root">
    <xsl:apply-templates />
  </xsl:template>
  <xsl:template match="Dept">
    <xsl:if test="not(preceding-sibling::node()[.=string(current())])">
      <xsl:value-of select="."/>
    </xsl:if>
  </xsl:template>
</xsl:stylesheet>

[Mahesh Chalil]

Using the Key mechanism it will be more simpler.

Thanks
-Mahesh