SQL SELECT – Return boolean based on condition

November 30, 2023 by Tarik

You don’t need a CASE expression
Just leverage how bit works: all non-zero values give 1 when cast to bit

SELECT
    u.Hostname,
    u.IsCustom,
    ~ CAST((u.Status = 5) AS bit) AS IsActive
from    SiteUrlMappings u