Posted by ZeldorBlat on 10/02/05 19:54

select clientID, FirstName, SurName, DOB
from CLIENTS
where DAYOFYEAR(DOB) >= DAYOFYEAR('2005-09-01')
and DAYOFYEAR(DOB) <= DAYOFYEAR('2005-10-01')

• Next in forum: Re: Birthday SQL Problem
• Prev in forum: Re: Birthday SQL Problem
• Thread view: Re: Birthday SQL Problem

[Reply to this message]