I want to Default my addnum column = null Where parcel.address_ID is null. Both in the same table.
In the Default Value or Binding Column properties i added this but its not working. ('Set addnum = null Where parcel.address_ID is null')
I would like my addnum column to be populated with a Address Vale or be null.
Addnum column is nvarchar(10)
Address_ID colunm is INT