DATEPART
select * from tablename where DATEPART(mm, datecol) = 7
select * from tablename where month(dob)='7'
select * from tablename where DATEPART(mm, dateofbirth) = 7 ;
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)