I am using sqlserver 2000.

I cant change the actual column, so I have to work on the query only.

Thanks for your reply.

I found if we query a ntext column, it does not result in full text, it cuts off in the middle.

I understand if we assign it to a...