Wildcard In A Date Field?

So I'm trying to see what is in our system with a 12/31 release date. I try this:

SELECT        UPC, ReleaseDate
FROM            Items
WHERE        (ReleaseDate LIKE '????-12-31')

But that doesn't return anything. If I change the date to Halloween 10-31 it still finds nothing, but I know we have things in our system with that release date. So where am I botching it up?


I'll assume that ReleaseDate is a date/datetime(2) column.

WHERE MONTH(ReleaseDate) = 12 AND DAY(ReleaseDate) = 31

Thanks worked like a charm.