aspnetdb SQL question

Ok assume I have these roles form authentication roles

AA, BB, CC, DD
And I realise that a user/member can have mutlple roles.


HOW Can I do a select SQL query that returns the result set like this (SQL 2005)
SELECT Roles FROM <tbl>
WHERE UserID = <GUID>
AND Roles IN ('AA','CC')

Result set..vertical format

AA
CC
Q: What would the TSQL be to do this in aspnet_ tables ?


Thanks



...