Hi,

Above mentioned query is given expected output in sql 2000 too.

I modified few settings in query analyzer in order to increase the maximum characters per column for result set and it worked.

But it’s not working for dynamic column query of my application.

I am trying to make it work.

Thanks