Identifying week range by todays date

[werosen1]

I'm trying to write an SQL query that identifies today's date, and then provides the date range for that date's week, so I can return all my database

records that fall in that week's date range and display them in my ASP page.

Is there a way to do this?

Regards