See if a user is a member of a group?

[Kumba1]

I want to set-up groups for my Database, and let certain login's be members of certain groups based upon what I want to allow them to do... My problem is this...

How do I check to see if the login is a member of a certain group on SQL? I'm using SQL Login, not NT Domain Auth BTW as well. Thanks....

 

[TimKThailand]

Try.

Select name
from dbo.sysusers
where (uid=
(select gid
from dbo.sysusers
where name=suser_sname()))