>I pass a date into my stored procedure as '05/31/2001' and want pull all records whos datetime field match that date. It seems the time portion of my datetime field causes the comparison not to match.
>
>Should I be using something like the datepart function and comparing the month, day and year or is there a better way.

Chris,

You can use the CONVERT() function to extract only the date portion.