Hello,
Just chk out this
SELECT mem_name FROM T1
WHERE((date_of_birth >= GETDATE())
AND(date_of_birth) <= DATEADD(DAY, 6,GETDATE()))
=====
Regards,
Manoj Talreja
/*Shoot for the moon. Even if you miss, you'll still land among the stars.*/
__________________________________
Do you Yahoo!?
Yahoo! Mail - now with 250MB free storage. Learn more.
http://info.mail.yahoo.com/mail_250
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspNetAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
