Thanks David....

Actually I started working on this and I am going in the similar directions that you mentioned.... In fact I am extracting words and their positions into other...

Hi Allen

Thanks for your reply...

Definitely FTS can do nearness search....but we cannot control that it should be within 3 words or 4 words ....beside to the main word....

Also I will...

Second option seems better. I have started working on this. While displaying how to transform rows to columns and how to write insert stored procedure to insert fields dynamically.