@ray M

Thanks for a quick reply. I modified it to varchar(max) .It gave me a table output but doesn't have data in it!