Add Label to to Paremeters

• sharonsql2013

  SSCertifiable

  Points: 5908

  More actions

  March 3, 2015 at 12:47 pm

  #298243

  Out of the 5 values I have in the parameter , one is NULL and another is ''

  I am trying to show them as "Not Listed"

  But under Available values , How can I add a single expression to club both values

  So, Label should show = Not Listed and Value should be ????

  If I individually added two rows , then I get two rows in the result set

  Any Ideas?