• I added a Null Value to the table that is used to populate the list-box, I select Null but I get no results.

    The Stored Procedure has the following criteria:

    AND ((@State IS NULL) OR (State = @State))

    I tried the following so I could get a multi-value drop-down checkbox but that did not work either:

    AND ((@State IS NULL) OR (State IN (@State)))

    For better, quicker answers on T-SQL questions, click on the following...
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/