how can I parse

hi
Can some one help my, how can I parse the following XML.
<WhoisRecord>
<CreatedDate>1996-03-27T00:00:00Z</CreatedDate>
<UpdatedDate>2004-06-21T00:00:00Z</UpdatedDate>
<ExpiresDate>2014-03-28T00:00:00Z</ExpiresDate>
<Registrant>
<Name>Microsoft Corporation</Name>
<Address>One Microsoft Way</Address>
<City>Redmond</City>
<StateProvince>WA</StateProvince>
<PostalCode>98052</PostalCode>
<Country>US</Country>
<CountryCode>US</CountryCode>
</Registrant>
<Domain>
<Name>HOTMAIL.COM</Name>
<UpdatedDate>21-Jun-2004</UpdatedDate>
<ExpiresDate>28-Mar-2014</ExpiresDate>
<CreatedDate>27-Mar-1996</CreatedDate>
<NameServer>NS1.HOTMAIL.COM</NameServer>
<NameServer>NS3.HOTMAIL.COM</NameServer>
<NameServer>NS2.HOTMAIL.COM</NameServer>
<NameServer>NS4.HOTMAIL.COM</NameServer>
<NameServerAddress>216.200.206.140</NameServerAddress>
<NameServerAddress>209.185.130.68</NameServerAddress>
<NameServerAddress>216.200.206.139</NameServerAddress>
<NameServerAddress>64.4.29.24</NameServerAddress>
</Domain>
</WhoisRecord>
Look up OPENXML in Books Online.
Adam Machanic
SQL Server MVP
http://www.sqljunkies.com/weblog/amachanic
"Farhan" <Farhan@.discussions.microsoft.com> wrote in message
news:ECCC3FA5-AC99-49D3-8E61-7D893BCAF7D1@.microsoft.com...
> hi
> Can some one help my, how can I parse the following XML.
> <WhoisRecord>
> <CreatedDate>1996-03-27T00:00:00Z</CreatedDate>
> <UpdatedDate>2004-06-21T00:00:00Z</UpdatedDate>
> <ExpiresDate>2014-03-28T00:00:00Z</ExpiresDate>
> <Registrant>
> <Name>Microsoft Corporation</Name>
> <Address>One Microsoft Way</Address>
> <City>Redmond</City>
> <StateProvince>WA</StateProvince>
> <PostalCode>98052</PostalCode>
> <Country>US</Country>
> <CountryCode>US</CountryCode>
> </Registrant>
> <Domain>
> <Name>HOTMAIL.COM</Name>
> <UpdatedDate>21-Jun-2004</UpdatedDate>
> <ExpiresDate>28-Mar-2014</ExpiresDate>
> <CreatedDate>27-Mar-1996</CreatedDate>
> <NameServer>NS1.HOTMAIL.COM</NameServer>
> <NameServer>NS3.HOTMAIL.COM</NameServer>
> <NameServer>NS2.HOTMAIL.COM</NameServer>
> <NameServer>NS4.HOTMAIL.COM</NameServer>
> <NameServerAddress>216.200.206.140</NameServerAddress>
> <NameServerAddress>209.185.130.68</NameServerAddress>
> <NameServerAddress>216.200.206.139</NameServerAddress>
> <NameServerAddress>64.4.29.24</NameServerAddress>
> </Domain>
> </WhoisRecord>