Hi I am trying to make more efficient use of the tables that I have, since the size seems to keep growing larger. I had my table fields to be all NOT NULL and hence i never had to do any checking, now I am planning on using this feature and allowing null fields in the tables. How would this affect my fetching row values? how can I handle this? Also do you really think i would be able to save anything with null? 90% of my fields are varchar(X) so if they dont have a value they will only consume 1 byte of space, so then would it make sense for me to make the fields null?

Thanks a ton Ankur