Hello Jeff,

Thanks for ur time and quick response..

Actually I did in otherway ..

In SSMS- tools-options--there i select results to text ..and changed the custom delimited to | ..and i ran that it worked for me..Saved the results to a file....

Thank you so much again...