In SQL Server, dates are stored as datetimes so if you are looking for a specific date, you either have to specify the entire value (date + time) or convert it into something manageable. The following can be used in your where clause:

WHERE convert(varchar(10),datetime_field,101) like "02/28/2000"

First parameter - type of value to convert to (in this case 10 character string)
Second parameter - field to convert
Third parameter - Style to convert to 1 - American, 2 - ANSI, 3 - British/French
Add 100 to value if you four digit year (as I have done)

HTH.