Specifying blank string in MSSQL Server Managment Studio
Avishkar Autar · Dec 19 2010 · Databases
If you want a specify a blank string in the Column Properties table (instead of writing a query) for something like the Default Value or Binding property, enter (”)
Just having ” will not work as that will actually insert 2 apostrophes.
h/t to Dhowe from this thread on bigresource.com