ID (nvarchar(64))
NAME(nvarchar(128))
ExtraInfo(nvarchar(MAX))

<ModifyMetadata>
    <hostName t="ws">host2</hostName>
    <Name t="ws">myname</Name>
    <modifiedFields t="lt">
        <ExtraInfoAdditionalField>
            <FieldName t="ws">foo</FieldName>
            <Values t="lws">
                <s/>
            </Values>
            <FieldType t="ws">String</FieldType>
        </ExtraInfoAdditionalField>
        <ExtraInfoAdditionalField>
            <FieldName t="ws">bar</FieldName>
            <Values t="lws">
                <s/>
            </Values>
            <FieldType t="ws">String</FieldType>
        </ExtraInfoAdditionalField>
        </modifiedFields>
</ModifyMetadata>

SELECT *  FROM [JOB]
  where  ExtraInfo like '%></s>%' ESCAPE ''

SELECT CAST(ExtraInfo as xml)
FROM [JOB]
WHERE ExtraInfo.value('XQUERYHERE') IS NULL

SELECT CAST(ExtraInfo as xml) as myinfo
FROM [JOB]
WHERE myinfo.value('XQUERYHERE') IS NULL