title: default value for column in SQL view
body: <p>I have an SQL view vith many columns.
  ID (land parcel ID) ex : 7465-85-7468
  Building (ID of a specific building if needed) ex : 102
  Room (ID of a specific room if needed) ex : 0023</p>
  
  <p>I have an ID for each row, but for most of the rows, there is not Building ID or Room ID</p>
  
  <p>I'd like to fill the blank rows with '000' for building, and '0000' for Room.</p>
  
  <p>I could Concat these fields in a fourth field (full ID)</p>
  
  <p>It tried to get a default value with "ISNULL", but it didn't work.</p>
  
  <p><strong>For Now, I have somethins like this</strong></p>
  
  <blockquote>
    <p>ID / Building / Room / Full ID</p>
    
    <p>7848-05-6956 /   /   /  7848-05-6956-- </p>
    
    <p>6985-26-7485 / 102 / 0000 / 6985-26-7485-102-0000 </p>
    
    <p>7236-12-0145 /   / 0223 / 7236-12-0145--0223</p>
  </blockquote>
  
  <p><strong>I'd need this</strong> </p>
  
  <blockquote>
    <p>ID / Building / Room / Full ID</p>
    
    <p>7848-05-6956 / 000  / 0000 / 7848-05-6956-000-0000 </p>
    
    <p>6985-26-7485 / 102 / 0000 / 6985-26-7485-102-0000 </p>
    
    <p>7236-12-0145 / 000 / 0223 / 7236-12-0145-000-0223</p>
  </blockquote>