|Subject||Re: [IBO] Altering values in search mode|
> I have a date column 'BIRTHDATE' (Dialect 3) where I save birthday ofThis is one way of doing it, but do you need to display the
> 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.
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?
L.S.Caine Electronic Services