>I would like to either have SQL server show me the names of the table fields in alphabetical order or allow me to copy them to a text editor to sort them.
>How would I do this?
>
Jim,
You can try to ask it nicely, like this
SELECT * FROM pubs.INFORMATION_SCHEMA.COLUMNS
WHERE table_name = 'authors'
ORDER BY column_name
--sb--