Question of the Day

BIT_COUNT II

In SQL Server 2025, I have a table (dbo.UserPermission) that contains this data:

UserID  UserPermissions
15
23
37
4       NULL

select bit_count(UserPermissions) as PermissionCount
from dbo.UserPermission
where UserID = 4;