title: Stored proceedure not returning all rows when it should. Whats wrong?
body: <p>In the Ques Table, some of the earlier added rows have AdminLangID column's value as NULL. The following SP should return those rows too but it's not. What is wrong? What condition do I need to add so it returns <em>ALL</em> the rows? I just manually set the AdminLangID of some rows, then it would return those, but not the ones with AdminLangID as NULL. I want it to return those rows as well. What do I need to change? This SP has been used to bind a grid on my page and the grid is rendering ONLY those rows that have AdminLangeID as NOT NULL.</p>
  
  <pre><code>BEGIN
   IF @QuesID = 0
    SET @QuesID =NULL
  SELECT     FQ.QuesID, FQ.Ques,QuesAns
  FROM         Admin.Ques FQ
  
  INNER JOIN Admin.Lang AL ON AL.AdminLangID=FQ.AdminLangID
  WHERE   FQ.QuesID = Coalesce(@QuesID,QuesID)
  END
  </code></pre>