Read XML value

Question

Hi Friends,

How can i read 117(LockboxID) value from below XML in sql server. Please help me

'<commdef>
<field name="to">[email protected]</field>
<field name="from">[email protected]</field>
<field name="subject">Alert: Amounts don’t match</field>
<field name="LockboxID">117</field>
<field name="body">

An exception was generated for LockBoxID=117.
Amount = 575.3600
Total = 276.2500
</field>
</commdef>'