title: How to return true or false from tsql using case when
body: <p>I'm trying to return true or false based on a CASE WHEN THEN tsql statement, but the only thing that ever shows up in the results panel is the column name "IsGeneric".</p>
  
  <p>Where am I going wrong?</p>
  
  <pre><code>alter proc Storefront.proc_IsProjectGeneric
  
  @ProjectID INT
  AS
  SET NOCOUNT ON;
  
  SELECT 'IsGeneric'=CASE WHEN p.[GenericCatalogID] &gt; 0 THEN CAST(1 AS BIT) ELSE CAST(0 AS BIT) END
                   FROM Storefront.Project p WITH(NOLOCK)
                   WHERE p.ID = @ProjectID;
  
  SET NOCOUNT OFF;
  </code></pre>