Avatar of Mark Wilson
Mark Wilson

asked on 

Extracting XML value

SQL 2008

I have the following example of xml in a sql column in a table

<CaseInception xmlns="http://www.smith.com/schemas/catch/bft" CaseTarget="C3">

I want to extract the <Soucrce> value from this (in this case) 001-001-34 from the xml

How would I do this?
Microsoft SQL ServerMicrosoft SQL Server 2008SQL

Avatar of undefined
Last Comment
Kyle Abrahams, PMP

8/22/2022 - Mon