How to query untyped xml data

[GinaMarano]

I have a varchar/text field that contains untyped xml. I don't want to use schema. How would one query this:

<configuration>
  <connectionsettings>
    <add key="appKey" value="355" />
    <add key="SessionURL" value="http://xxxxxx" />
    <add key="UpdateOrderURL" value="http://yyyyyyy" />
    <add key="IgnoreFailure" value="true" />
  </connectionsettings>
</configuration>

I want the "value" for 'IgnoreFailure'

DECLARE @x XML
select @x = myColumn from myTable where recordid = 1
select @x.query(...

~Gina_M~

[GinaMarano]

Got it!

Select @x.value('(//connectionsettings/add[@key="IgnoreFailure"])[1]/@value', 'varchar(MAX)')

~Gina_M~

[Delerna]

I love it when somone solves their own question.
I love it even more when they let us know.
Good job Gina_M :)

[Steve Hindmarsh]

I hate it when this happens, what the devil is @x.value ?

[ck9663]

Steve,

Read this

Good Luck!!!

~~ CK