title: How to check null values in select all query?
body: <p>I have a situation in which I need to select all columns from a table and the query is something like:</p>
  
  <pre><code>select     sr.*,
             cs.subjectid,
             cs.priority,
             cs.subjectname   
  from       sometable sr,   
             otherTable cs   
  where      sr.col1='E2011FT0'   
    and      sr.col2='5'     
    and      sr.col3=  '66018'  
    and      cs.col1=sr.col1
  order by   cs.col2;
  </code></pre>
  
  <p>How do I check for null values in the <code>sr.*</code> columns and replace them with a different value? There are a lot of columns in the <code>sometable</code> table and I'm trying to avoid listing them all explicitly.</p>