title: Getting default extra bool value in the select query in SQL Server
body: <p>How we can specify a bool default value in the select query. I am doing a select using the below mentioned query.</p>
  
  <pre><code> select null as [&lt;TABLENAME&gt;MyTable&lt;/TABLENAME&gt;], 'true' [IsCancel], name, age, location from @TempTable
  </code></pre>
  
  <p>Now the 'true' is coming as string. But how can I get an exact true boolean value in the [IsCancel] column ? </p>
  
  <p>The @TempTable contains only 3 columns [name, age, location]. But 
  I dont want to put a boolean column in the @TempTable.</p>
  
  <pre><code>  declare @TempTable table (
       name       varchar(20) default ''
      ,age            int
      ,location       varchar(50) default ''      
  );
  </code></pre>