set datefirst 1   -- start weeks on mondays

select  datecolumn

from myTable

where datepart(dw, datecolumn) = 5

Have a look in BOL at DATEPART for further info on datefunctions.

/Kenneth