Thanks Drew,

Works perfectly , I'm sorry, I forgot to add the there is a "Text" field if Checked=true.

I tried to add it in , but not getting the output I...

Hi Eirikur,

Thanks for getting back

So in the example , the output for "Purpose of  Request" would be " 'New Bill, Additional Spending money/Leisure' since only those two are checked=true.

But all...

Hi

So here is some sample code for the first 15 fields

and attached  is a sample of the entire XML

Thanks

SELECT People.[First Name],
      ...

Thanks Lynn,

let  me work on this and I'll send a better sample

Sorry for being SO vague, just wasn't sure what to ask....

So the XML, I posted was part  of a layout I received for data to send on a monthly basis...

Sorry

Also alot of tables are being called from another Database

Ahh got it!

Works as I need . I wrote the data out to a temp table using a cross apply then chose the values as needed .

Thank you

Thank You

Eddie and Drew...

I appreciate the info and the learning experience....

Hi Eddie

Thanks so much, I get the logic, but not to sound dumb...

How do I incorporate this into a select statement ?

where 'data' is coming from xdoc table

FROM data.dbo.CalendarEvents AS...

Got it...

needed Double quotes encasing the double quotes in the text ...

Thanks for your time...

CASE

WHEN x.Data.exist('Data/Treatment_x0020_Focus/PACT_x005F_x0020_Service_x005F_x0020_Note_Treatment_x0020_Focus_Option

[Name="N/A = Skip to ""Other Information"""][Checked="true"]') = 1

THEN 'Yes'

END AS [NA],

This is the XML data

</Location>

<Treatment_x0020_Focus>

<PACT_x005F_x0020_Service_x005F_x0020_Note_Treatment_x0020_Focus_Option>

<Name>N/A = Skip to "Other Information"</Name>

<Checked>true</Checked>

</PACT_x005F_x0020_Service_x005F_x0020_Note_Treatment_x0020_Focus_Option>

Thanks Scott

That works great!!

Hi Eddie
Sorry, one more question on this 
Can I grab the "Name" field if the "Checked" field is 'True'?
if the field is setup as a for only one...