Jbalbo

Hi 

Having trouble parsing an XML field in SQL.

Usually I do something like

      data.value('(/Data/...)[1]', 'varchar(10)')
 

But not sure how to parse out say "Case" in the example below?

<Parameters xmlns="http://www.www.com/WebFramework/WorkflowParameters.xsd">
  <Parameter Name="ClientID" StringValue="12903166" />
  <Parameter Name="Workflow_ActiveSlide" StringValue="317" />
  <Parameter Name="Document_First_UserID" StringValue="8577430" />
  <Parameter Name="Program" StringValue="120555" />
  <Parameter Name="Workflow_ActiveUser" StringValue="9137070" />
  <Parameter Name="Document" StringValue="14317336" />
  <Parameter Name="Case" StringValue="12903171" />
  <Parameter Name="ProgramSite" StringValue="152" />
</Parameters>

Thanks