SQL Pro Question?

[Florian Bogeschdorfer]

Hi

I have a DB with persons and their birth date. The birth date is of type
kDate

Now what can I do to find all people who have birthday in MAY for example or
in the current or next week or current or next month? I mean not in this
year. If I search for all who have birthday in May, I need as a result e.g.:

12.05.1978
16.05.1999
22.05.1982

Ideas ?

Thank you ,

Florian