I am really struggling with this and must get this somehow. Can anyone please help me.
I have a column in this table called "PropertyBagxml" and it contains XML data. There is one field and value in this XML file that I need to query on.
My query is going to say something like IF xml field value = True then "yes" else "no"
So here is the sample of the XML file:
- <v:ConditionDelegate i:nil="true" />*
- <v:CreatedBy>O'Neal, Charlton</v:CreatedBy>*
- <v:CreatedWhenUTC xmlns:d1p1="... http link here...">*
The statement I need to query against is the one that states: <v:IsConditional>false</v:IsConditional>
Can someone help me with this, PLEASE!!
Thanks. First time posting on here so be nice