> I have a date column 'BIRTHDATE' (Dialect 3) where I save birthday of
> persons.
> The user enter the date of birth in a other column and on triggers I fill
> the column 'BIRTHDATE' always with the day and month of the date of birth
> just entered and the year=400.

This is one way of doing it, but do you need to display the
year?

Because you need to 'play' with the search, you may find it
easier just to store MONTH * 100 + DAY, and then process the
search input in the same way. I use this all the time with
times and it's easy to check things out as looking at the
raw data you have mmdd as a simple number.

Just an alternative and it only needs to be SMALLINT - don't
know if that helps speed up the indexes?

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services