Hi All,

I remember in Access, you can specify a caption for a particular field name in a table. How do you do that in SQL Server? I can do a query like:

SELECT field1 AS fieldname1, fieldN AS fieldnameN FROM sometable

This is fine but to dynamically display data from the table, and easily binding that table to a grid of some sort, it is much better if the database table's caption property be set instead of the above query. I might be missing something with regards to setting this property in SQL Server. Any ideas? Thanks!