title: Need BOOLEAN Result from SQL EXISTS Statement without using a WHERE Clause
body: <p>Is there any way in a simple query to return a Boolean value using an SQL EXISTS statement without using a WHERE clause?</p>
  
  <p>All of the 2008 R2 SQL Server Books Online examples show another WHERE clause and two tables.  Website examples show either a WHERE or an IF-THEN-ELSE in a procedure.</p>
  
  <p>I was hoping to do the following on one table:</p>
  
  <pre><code>EXISTS
  (SELECT  cx.id
   FROM fdd.admissions_view as cx  
   WHERE cx.id=1111 and cx.campus='MEXI') 
  </code></pre>
  
  <p>The SELECT statement works fine and returns the ID. I just want to add EXISTS to return a BOOLEAN, but the syntax above is not valid. </p>
  
  <p>Can I do something like this?  If so, what am I missing syntax-wise?  If not, what other technique may work?</p>
  
  <p>Please advise.  Thanks. </p>