Problems with a Sql 2005 query and XML

HTML & CSS
1

Hi all,

i have a query like this


SELECT
         *
FROM
         TABLE
FOR XML RAW('ROW'), ROOT('DATA'), ELEMENTS

This code returns the contents of “Table”, in the XML Editor, shows all the content without problems, but when i do a response.write in my asp.net page, it shows me about 2000 characters… when i put a filter in the query, for have less than 2000 chars, it shows it OK

any solutions??

REGARDS!