Subject Re[2]: [firebird-support] select birthdays form the next several days
Author Pavel Menshchikov
Hello Christian,

CB> This cannot work, as most of the people don't have birthday in the same
CB> year. I can use this with my second idea (with a second column with a
CB> fixed year) but not on the original dates.
:) Sorry, I need to sleep more :)

Then create another field with 'mmdd' as John suggested, [index
it,] and use trigger(s) to populate it. (it's my prefer :)



--
Best regards,
Pavel Menshchikov
http://www.ls-software.com/