>
>The character fields are only part full, is they any way to save space?
>
Do you have real problems with disk space? Generally speaking, if your database is structured properly then half-empty character fields should be the least concern. Maybe you can split this field on two or more and/or use related table, but I would not recommend using memo just because you want to save space. Memo is used when you want to keep more than 255 characters.
Edward Pikman
Independent Consultant