Hi John,
I see your point, but you are talking about DAY of birth and I am talking about actual birthday date like in case:
select * from CLIENTS where between (birth_date, {01/01/1955}, {01/01/1965})

:)

>Nick,
>
>Whoops. Won't work. My birthdate is 5/26/1960 but if I need birthdays between 5/1/2000 and 5/31/2000 this won't work.
>
>
>
>>SELECT * from CLIENTS WHERE BETWEEN(birth_date, ldInitial_date, ldFinal_date)