title: Reverse boolean (bit) value in SQL CE select statement
body: <p>I am trying to write a query that gets table information from a <code>SQL CE</code> database, ready to be put in c#, later to be exported to XML. I need one of the columns to be named 'IDENT' with a boolean value (to represent whether or not it is the identity column, obviously).</p>
  
  <p>For this, I am checking if the AUTOINC_SEED column is null, as follows:</p>
  
  <p><code>select isnull(AUTOINC_SEED) as IDENT from information_schema.columns</code></p>
  
  <p>However, this returns TRUE for non-identity columns and FALSE for identity columns! Is there any way to reverse the boolean value inside the select statement?</p>
  
  <p>Edit: I'm aware I could do a case statement to solve this particular problem, but it got me curious about inverting boolean (bit) values in SQL.</p>