I'm trying to write a xsl file to transform this

                                   - <WhereDetails Operator="OR">
                        <Description Name="accountid" Condition="=" Value="
                      1000" Operator="And" />
                        <Description Name="SortCode" Condition="=" Value="
                      1001" Operator="Or" />
                        <Description Name="accountType" Condition="=" Value
                      ="Saving" Operator="" />

</WhereDetails>

                  in to this
                  - <WHERE>
              <Clause Value="accountid = 1000 And sortCode = 1001 Or
            accountType = Saving  " />
            </WHERE>

Here , we need to take care of one point......
1. If there is no operator is defined in <Description> node then we need to
take the Operator which defined in <WhereDetails> node.

<xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform">	
	<xsl:template match="WhereDetails">
		<WHERE>
			<xsl:attribute name="Value">
				<xsl:apply-templates/>	
			</xsl:attribute>
		</WHERE>
	</xsl:template>
	<xsl:template match="Description">
		<xsl:value-of select="@Name"/>
		<xsl:text> </xsl:text>
		<xsl:value-of select="@Condition"/>
		<xsl:text> </xsl:text>
		<xsl:value-of select="@Value"/>
		<xsl:text> </xsl:text>
		<xsl:choose>
			<xsl:when test="@Operator">
				<xsl:value-of select="@Operator"/>
			</xsl:when>
			<xsl:otherwise>
				<xsl:value-of select="../@Operator"/>	
			</xsl:otherwise>
		</xsl:choose>
		<xsl:text> </xsl:text>
	</xsl:template>
</xsl:stylesheet>

--
Oleg Tkachenko
Multiconn International, Israel