Null indicates the absence of data, which is distincly different than an empty string or a zero. There is no speed benefit, however. In addition, all fields that are not nullable will require a default value in the column properties or you must hard-code the default value in all of your INSERT commands.

>Hi all,
>
>What is the advantage when we allowing Null data type to each data field?
>
>Thanks alot
>Aston