Column Header and Results Formatting

[benhsmith]

I am using SQL 6.5 and require to have the results of my query to appear without column headers and as Tab Delimited.

i realise that I can do this through the 'Query Options' in the menu bar but I need to set this using an SQL statement in the query itself (Similarly to 'set rowcount' or 'set nocount off').

Please Help!!

 

[JFoushee]

Without knowing what your values are within your query, you can force the tab character into your result set as such:

SELECT varchar_field + Char(9) + Convert(int_field, varchar(3)) + Char(9) + ...

That way, not only do you lose the column names, you also get your Tab delimiter. Hope this helps.