You can use a bunch of date functions as shown below.

lnDaysBack = 5   
SELECT *, Month(dob) AS MonthDob, Day(dob) AS DayDob ;
  FROM mytable ;
  WHERE dob BETWEEN DATE( YEAR(dob), MONTH(DATE()-lnDaysBack), DAY(DATE()-lnDaysBack)) And ;
                    DATE( YEAR(dob), MONTH(DATE()), DAY(DATE())) ;
  ORDER BY MonthDob, DayDob ;
  INTO CURSOR csrReult

>i have a date field which stores the birth date of employees.
>
>i want to extract (thru' sql) those employees whose birthdays fall 4-5 days before the system date on any given day and i would like to have the list sorted on only the day of the month value and not the entire date field