InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSat, 25 May 2013 05:00:44 GMT20http://www.sqlservercentral.com/Forums/Topic480594-1245-1.aspxDOB???Not a good question.By the way DATENAME(datepart, date) returns 'February' when datepart is month and month(date) is 2...so the second one is right.Mon, 07 Apr 2008 03:26:03 GMTmirko.danzihttp://www.sqlservercentral.com/Forums/Topic480594-1245-1.aspxPoor explanation of the answer, the author just assumed that FEB is = FEBRUARY and also the DOB = DOJ.I need my points desperately.Sun, 06 Apr 2008 23:34:11 GMTManish_