title: In a stored procedure if value is empty space or Nil change that value to others :SQL
body: <p>I have this stored procedure and I want to replace the column value in case if its empty string or Nil as written than those values should be changed to "others". I tried the replace function, but that did not fit with there. The values I get them in a dropdownlist </p>
  
  <pre><code>if(@Type='2')
  Begin
      select distinct APlan.FlightNumber
      from tblArrivalPlan APlan
      where (Status=5 or Status=7 or Status=68)
  
      --select replace (APlan.FlightNumber,'004','JackSparrow') 
      --from tblArrivalPlan APlan
  end
  </code></pre>