Need to sort column headings in query or report

[ACTHelp]

Hey everyone, I have a table which was imported from another application. I need either a query or a report which will sequence the results by column heading. See example below (this is a simplified example...my actual data has 1800 fields...)

So if my input is like this:

City Address State
Kenosha 3948 8th Avenue WI
Racine 8833 Lathrop Ave WI

I would like a query or report to look like this:

Address City State
3948 8th Avenue Kenosha WI
8833 Lathrop Ave Racine WI

 

[PHV]

And where is the problem ?
In a query you choose the fields in the ordinal position you want in the SELECT instruction:
SELECT field2, field1, field3
FROM yourTable

my actual data has 1800 fields
???
JetSQL don't admit table with more than 255 fields ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886