Thanks for support by all,

Actually I am supposed to carry out testing of data integration for my client, and have to show them results in interprise manager or Query Analyzer first and then counter check in the interfaces. The data is scattered in lots of tables and I want to show the records in one screen rather than a huge list of scrollable records.

I tried to used char(13) and char(10) sort of things but they didn't work.