>>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
>

You never cease to amaze me.
It worked great

Thanks
Jim