title: Return 'Yes' or No' from select statement?
body: <p><code>tbl_LoanSummary</code> has <code>Sample_Number</code> column. I have to check if <code>Sample_Number</code> column is not null the return 'Y' otherwise return return 'N' from below select statement.</p>
  
  <pre><code>  select a.Br_Loan_No ,a.Br_LookupKey, //return  IsNull(s.Sample_Number) ='N' or 'Y'                            
    from dbo.tbl_Br a left outer join dbo.tbl_LoanSummary s 
    on s.Loan_no = a.Br_Loan_No order by a.Br_Loan_No
  </code></pre>
  
  <p>How to do this?</p>