Home Forums SQL Server 2005 SQL Server 2005 General Discussion Extracting xml data from text column RE: Extracting xml data from text column

  • February 19, 2013 at 10:00 am

    #1589284

    I ended up using ths logic below and it did the trick.

    convert(xml,pm.XmlProfile_TXT).value('/XMLProfile[1]/DID[1]', 'varchar(30)')

    Thanks everybody for your input and good suggestions! This post is now completed.

    -Dave