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 NoAs you can see, the LONG field names are truncated, with ".." appended.