Thanks Steve. I knew it was something stupid.

Only there? :omg: Daily WTF Memes

I figured it out I had to convert to text stream and then use derived column add as new column (DT_STR,4000,1252)(DT_TEXT,1252)[Description] What a pain!

Wow thats a lot simpler. Thanks a lot. I have a bad habit of reverting to cursors when I cant get something to work. For a Canadian your all right. (Just kidding my sister lives in Toronto)

I'm not sure I understood what you need... Try this: WITH XMLNAMESPACES ('uri1' as media, 'uri2' as live) SELECT RTRIM(Title) AS 'media:title' , [Description] AS 'media:description' , Url AS 'live:link' , DateCreated AS 'media:pubdate' , thumbnail AS 'media:thumbnail' FROM dbo.Videos FOR XML PATH('item'), ROOT('root')

I rebuilt the whole page and problem fixed.