Hi,

When I run this it will success fully executed.I changed it @i+=1 to @i=@i+1;

but it will show result as with out using for xml.

after for xml i executed but it opened on SSMS.But i saved it in the form XML.With IE i am unable to open.With for xml it shows in different.Please explain in detail abot this characters.but i understand that this char will return the value of the character.suppose char(65) will return A.but and also 32 is space i think.what are the charcters below 32.The result of sample data as shown below.

<_x0023_t a="" />

<_x0023_t a="&#x1;" />

<_x0023_t a="&#x2;" />

<_x0023_t a="&#x3;" />

<_x0023_t a="&#x4;" />

<_x0023_t a="&#x5;" />

<_x0023_t a="&#x6;" />