i am inherited the database from previous developers. I think they have it set “ ” and some 0. I have at least two different date in the table 1753-01-01 and 1953-01-01, don't know if any more out there. My question is how can i query only the records for those date ? select.... from... where year(dateAdded in ('1753', '1953') or what if i don't know if it has any other date there that sql automatice coverted into?