title: sql query - true => true, false => true or false
body: <p>Simple query, possibly impossible but I know there are some clever people out there :)</p>
  
  <p>Given a boolean parameter, I wish to define my where clause to either limit a certain column's output - or do nothing.</p>
  
  <p>So, given parameter @bit = 1 this would be the result:</p>
  
  <p>where column = 1</p>
  
  <p>given parameter @bit = 0 this would be the result:</p>
  
  <p>where column = 1 or 0</p>
  
  <p>i.e. have no effect/show all results (column is a bit field)</p>
  
  <p>I'm not wanting dynamic sql - I can settle for fixing this in code but I just wondered if there's some clever magic that would make the above neat and simple.</p>
  
  <p>Is there? I'm using sql server.</p>
  
  <p>cheers :D</p>