A charcter field is limited to 254 bytes. You'll have to use a memo to store 255 characters or more.
>I am merging two tables. Each one contains data on documents contained in a library. The first uses character fields for most of its data types but does have 2 memo fields. The second uses memo fields (5) for most of its columns. The second table is the smaller of the two (about 1/3 the records of the first). Assuming the data in the second table's memo fields can be contained in character fields 255 wide, would the best choice be to continue using memo fields in the combined table or to convert the memo fields to character fields to match the first table? The combined number of records is fairly small (6000) so disk space is not much of an issue. The application will be webbased.
>
>What would you recommend regarding pros and cons either way?
>
>Thanks
--sb--