Get student details from [B]tblDNFRec[/B] table whose joining month is "January".

Get student details from tblDNFRec table whose joining month is "January".

Select * from tblDNFRec where SUBSTRING(convert(varchar,joining_date,100),1,3)='Jan'

Thanks
Amatya