SQL Server populating a drop-down result set with Null
Posted on 2014-09-18
I have a drop down populated with a values from a table lets call SalesContacts. Currently if someone selects any one of these contacts I take the selected value, set it to variable and essentially do a lookup/filter to display only the data of the selection.
My problem is if someone wants to clear the data they can not clear the data since I have no value called Null in the set of values. How do I populate an additional value called Null for the universe of values ?