Thanks for the help both of you - i got it working but i have 1 issue if there is multiple attachments
Im inserting into Audit table
INSERT INTO [dbo].[Audit]
realXML.value('(/Announcement/Template)', 'VARCHAR(50)') AS [Description],
realXML.value('(/Announcement/Full_News/Announcement_Details/Attachment)', 'VARCHAR(100)')AS [Attachment],
CONVERT(XML,CAST(AnnouncementXML AS NVARCHAR(MAX)), 2)
It will only pick up the first attachment, i know i need to do Attachment , Attachment up to  etc.. but i dont know how to incorporate it in the code....