select birthday query

Hi

I am making a birthday database. I have saved date of birth as '12-12-1985' Now i want to select all the birthday that are in December, Need help in query if possible.

Regards,
dizyn

 

try:
Select * From Table
Where Month(Convert(datetime, birth_col)) = 12

 

Doron, you are a God, I have had this same problem for few days and now have it fixed. Thank you sir!