Wildcard In A Date Field?

Transact-SQL
1

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?

Thanks

2

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


WHERE MONTH(ReleaseDate) = 12 AND DAY(ReleaseDate) = 31
2 Likes
3

Thanks worked like a charm.