Thanks!

That got me thinking!!!

Here is what I did!

COPY STRUCTURE EXTENDED TO C:\TEST\FIELDS
USE c:\test\fields
LIST FIELDS FIELD_NAME,FIELD_TYPE, FIELD_LEN, FIELD_DEC TO FILE C:\TEST\FIELDS.TXT

And then loaded this into a text editor!

Thanks again!
Tommy

>Afields()?
>
>>Hello Gurus!!
>>
>>For the first time, I've run into this problem!!! Guess I never used LONG field names before!!??!!
>>
>>When using the DISPLAY STRUCTURE command on a table with LONG field names, I get this output....
>>
>>

>>
>>Structure for table:                   C:\PHARMACY\TABLES\DRUG.DBF
>>Number of data records:       191274
>>Date of last update:          11/28/06
>>Memo file block size:         64
>> Code Page:                   1252
>>                Field        Field Name                                                            Type                                                                                                   Width                           Dec                   Index   Collate                                            Nulls                               Next                               Step
>>                    1        DRUG_ID                                                               Integer                                                                                                    4                                                   Asc   Machine                                               No
>>                    2        NDC                                                                   Character                                                                                                 11                                                                                                               No
>>                    3        ACTIVE                                                                Logical                                                                                                    1                                                                                                               No
>>                    4        NAME                                                                  Character                                                                                                 25                                                                                                               No
>>                    5        FORM                                                                  Character                                                                                                  3                                                                                                               No
>>                    6        STRENGTH                                                              Character                                                                                                  8                                                                                                               No
>>                    7        SIZE                                                                  Numeric                                                                                                    8                             3                                                                                 No
>>                    8        DEA_CLASS                                                             Character                                                                                                  1                                                                                                               No
>>                    9        THIRD_PARTY_..                                                        Character                                                                                                  1                                                                                                               No
>>                   10        MANUFACTURER                                                          Character                                                                                                 30                                                                                                               No
>>                   11        SHORT_NAME                                                            Character                                                                                                 23                                                                                                               No
>>                   12        SHORTCUT                                                              Character                                                                                                  8                                                                                                               No
>>                   13        DRUG_TYPE                                                             Numeric                                                                                                    1                                                                                                               No
>>                   14        TOT_PKG_QTY                                                           Numeric                                                                                                    6                             3                                                                                 No
>>                   15        PKG_UNIT_MEA..                                                        Character                                                                                                  2                                                                                                               No
>>                   16        PKG_QTY                                                               Integer                                                                                                    4                                                                                                               No
>>                   17        DRUG_NAME_CO..                                                        Character                                                                                                  6                                                                                                               No
>>                   18        THERAPEUTIC_..                                                        Character                                                                                                 10                                                                                                               No
>>

>>
>>As you can see, the LONG field names are truncated, with ".." appended.
>>
>>Is there a workaround so I can get an output WITH the long field names so I can easily cut and paste the names???
>>
>>Thanks!!!