Evaluating XPath Expresssions

XPath Result of XPath Evaluation
distinct-values(/FitnessCenter/Member/FavoriteColor) 
lightgrey
lightblue
lightyellow
purple

The XML Document

<FitnessCenter>
        <Member id="1" level="platinum">
                <Name>Jeff</Name>
                <FavoriteColor>lightgrey</FavoriteColor>
        </Member>
        <Member id="2" level="gold">
                <Name>David</Name>
                <FavoriteColor>lightblue</FavoriteColor>
        </Member>
        <Member id="3" level="platinum">
                <Name>Roger</Name>
                <FavoriteColor>lightyellow</FavoriteColor>
        </Member>
        <Member id="4" level="platinum">
                <Name>Sally</Name>
                <FavoriteColor>lightgrey</FavoriteColor>
        </Member>
        <Member id="5" level="platinum">
                <Name>Linda</Name>
                <FavoriteColor>purple</FavoriteColor>
        </Member>
</FitnessCenter>