Msg#: 3784254 posted 5:40 pm on Nov 11, 2008 (gmt 0)
I have a date column in a table that displays the date for a given record like this "November 10, 2008". What would my sql statement look like if I just wanted to find all of the records from "November".
WHERE Date = "November" doesn't work for me, I get no records found. I need to look past the day and year.
Msg#: 3784254 posted 6:28 pm on Nov 11, 2008 (gmt 0)
It would be better if you can change the field type (and underlying data) to DATETIME instead of VARCHAR (or at least add another field of type DATETIME). Using VARCHAR fields to store dates is just asking for problems later on.