FOR XML output results

Hi,

I've a problem with the result of a FOR XML EXPLICIT query. the output is ok but it suddenly stops. it looks like there is a limit on characters or something.

The output is:

<b100><b110>2141287</b110><b120>GB</b120><b130>A1 </b130><b140>1984-12-12T00:00:00</b140></b100><b200><b210>08408789</b210><b210a>1984 1234</b210a><b211>A</b211><b220>1984-04-05T00:00:00</b220><b250>Kat</b250><b260>Kat</b260></b200><b300><b310>05244683</b3 --and here it stops!!

Does anyone know how to solve this problem?

Greetings,
Renehttp://www.sqlteam.com/forums/topic.asp?TOPIC_ID=25662

macka.