>I'd like to select all rows from a table containing the column daynumber(int) (Sunday = 1) for a range of dates
>
>Any ideas?

This could work:

SELECT * FROM Member
 WHERE Member.AddDate>='1996-01-21 00:00:00.000' AND Member.AddDate<='1996-03-24 23:59:59.999' AND DATENAME(DW, Member.AddDate)='Sunday'