Home Forums Programming XML Simple value method help RE: Simple value method help

  • OK, thanks to Matt's link & insights, I was able to get this to work without having to resort to MS's three line preamble:

    Select @xml.value('(/*:Error/*:_Description/text())[1]', 'nvarchar(255)' )

    The underscore is just to deal with this forum's Smiley Face stuff that should be disabled in Code Blocks anyway.

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.
    [/font]
    [font="Verdana"] "Performance is our middle name."[/font]