Hi,

I have been told not use Allow NULLs when defining an SQL Table. So I do not allow nulls in all fields.

Everytime I turn around the app give me a message:

System.Data.NoNullAllowedException: Column 'FileNum' does not allow nulls. This is an auto Increment field. All other fields will do the same thing if you do not enter a value.

All SQL fields have a default value of '' Should I use something else like leaving the default blank (nothing) or ' ' one space or make it the number of spaces that is allowed in the field?

What is the best way to handle allow null for fields using SQL Server 2000 and VB .net?

Thanks
Roland