At 12:12 -0700 5/1/03, Richard Reina wrote:
>I have a table called contact with a column called birthday so we
>can be allerted of a contact's approaching birthday. SInce the year
>is not necessary and often times hard to obtain we have made the
>field a character field storing the month and the day. This however
>makes it difficult to query and requires a lot complicated *if *
>statements in the code. Does anyone know a better way?
Three separate integer columns, with the year column allowed to be NULL?
>
>Richard
--
Paul DuBois
http://www.kitebird.com/
sql, query
