How to return true or false from tsql using the case where

Question

I am trying to return true or false based on the CASE WHEN THEN tsql statement, but the only thing that ever appears in the results pane is the IsGeneric column name.

Where am I going wrong?

alter proc Storefront.proc_IsProjectGeneric @ProjectID INT AS SET NOCOUNT ON; SELECT 'IsGeneric'=CASE WHEN p.[GenericCatalogID] > 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; 

Answer 1

You use apostrophes around the identifier, which makes it a string instead.

 SELECT IsGeneric = CASE WHEN p.[GenericCatalogID] > 0 THEN CAST(1 AS BIT) ELSE CAST(0 AS BIT) END FROM Storefront.Project p WITH(NOLOCK) WHERE p.ID = @ProjectID; 

Answer 2

 SELECT CASE WHEN p.[GenericCatalogID] > 0 THEN CAST(1 AS BIT) ELSE CAST(0 AS BIT) END as IsGeneric