Query: View Groups for a specific Right

Select * from [Group] where [Id] in
(Select [GroupId] from [UserGroup] where [UserId] = 1) and substring([Rights], X, 1) = '1'