>Tom,
>
>If one audits the data that flows in and out of a database, then even with char and varchar data types, a NULL or a space is a significant difference. A NULL means that data was never entered. A space means that something was entered at one time and then someone changed their mind and got rid of it at a later time. That seems significant to me. ;)

Bonnie,

We're using triggers for auditing data. I don't see any benefits in using Nulls for that purpouse.