Imply bit with constant 1 or 0 in SQL Server
cast ( case when FC.CourseId is not null then 1 else 0 endas bit)The CAST spec is "CAST (expression AS type)". The CASE is an expression in this context.
If you have multiple such expressions, I'd declare bit vars @true and @false and use them. Or use UDFs if you really wanted...
DECLARE @True bit, @False bit;SELECT @True = 1, @False = 0; --can be combined with declare in SQL 2008SELECT case when FC.CourseId is not null then @True ELSE @False END AS ...
You might add the second snippet as a field definition for ICourseBased in a view.
DECLARE VIEW MyViewAS SELECT case when FC.CourseId is not null then cast(1 as bit) else cast(0 as bit) end as IsCoursedBased ...SELECT ICourseBased FROM MyView
No, but you could cast the whole expression rather than the sub-components of that expression. Actually, that probably makes it less readable in this case.