Ok, many thanks to both of you. I'll take a look at both of these options.

Bill

>>When creating table columns ( through the IDE ), one of the optional paramters that can be entered is the column's "Description". Where is the "Description" data for the column stored and is it possible to query it? If so, how?
>>
>>I have tried sp_columns and sp_columns_rowset and neither produces this column data. The output sp_columns_rowset contains a "Description" column but the values in it are always NULL.
>>
>>Thanks,
>>Bill
>
>This works on SQL 2005 (I can't test it right now on SQL 2000)
>

>SELECT *
> FROM sys.extended_properties
>LEFT JOIN INFORMATION_SCHEMA.Columns
>ON OBJECT_NAME(Major_Id) = INFORMATION_SCHEMA.Columns.Table_Name AND
>   Minor_Id = INFORMATION_SCHEMA.Columns.Ordinal_Position
>WHERE Class = 1
>