I am new to this list. If I have 8 text fields that I want a table to have, would it be better to use 8 Note fields vs. 8 Text fields of 80 characters?
Would the Note fields use less disk space that the allocated Text fields of 80 characters? I know this would allow me to use more than 80 characters in some of the fields, so that would be a benefit. Are there any draw backs to a Note field? Also, will I lose any data in a Text field that I convert to a Note Field? Thanks Steve Fogelson Internet Commerce Solutions
