New column value baed on xml string column tag

Question

Hi

I have table with nvarchar(max) column where i stored xml string.
in that xml column some xml column having <Attachment> tag some not.

what am expecting is, i need one new column as 'Attachment'. if that xml string column having <Attachment> tag then it should be 'YES' else 'No'

Thanks in Advance

Answer 1

Hi @kasim mohamed
Try this:

SELECT File_xml,CASE WHEN PATINDEX('%Attachment%',File_xml)>0 THEN 'YES' ELSE 'NO' END AS Attachment  
FROM xml_table  

Best regards,
LiHong

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.