>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'