Subject | Re: [IBO] Altering values in search mode |
---|---|
Author | Luiz |
Post date | 2002-02-13T23:05:36Z |
Lester,
----- Original Message -----
From: <lester@...>
> 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?
I didn't think about this alternative. Helen suggested another approach, but
I will try your tip.
Thanks,
Luiz.