datepart/datename

Question

Hello,

I have a table containing the following columns

TrailerID

ScheduleDate

ActualDate

AcutalCube

     
I would like to pull the trailerID if the day of the week is, say Tuesday.  I have found I can get the day of the week for a specific row using datepart, however I would like to pull all rows for a given day of the week.  I have tried the following

select * from summary where datepart(dw, ' ') = '5'.  (the name of the table is "summary".)

The query executes successfully with 0 rows.  The results of the query are to be pulled into C# and then put into a structure for further manipulation.  If I can avoid pulling all of the rows in sql then altering it in C# to only those I want that would be wonderful.