Get given character's position from a string

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(3)

You rated this post out of 5. Change rating

2008-02-13 (first published: 2007-12-18)

1,736 reads

Blogs

A cryptic message, a book cipher hidden in art provenance records, and a trail...

A customer was trying to compare two tables and capture a state as a...

When I'm looking at a query, I bet it's bad if I see... a...

WA:08218154393 Jl. Perak Bar. No.267, Perak Utara, Kec. Pabean Cantian, Surabaya, Jawa Timur 60165

Comments posted to this topic are about the item BIT_COUNT II

Comments posted to this topic are about the item I Can't Make You Learn

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

UserID  UserPermissions
15
23
37
4       NULL

What is returned when I run this code:

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