title: SQL Server 2000 - Default Value for varchar fields
body: <p>I have a sql server nvarchar field with a "Default Value or Binding" of empty string.  It also happens to be a not null field.</p>
  
  <p>Does this mean that there is no default or that it is a default of a string with no characters in it.</p>
  
  <p>If I don't insert a value, will it insert with an empty string or fail with a "not null" error?</p>