does TFI_PERSON have a date of birth column stored as datetime format?
why this
[DOB_DAY] [int] NOT NULL,
[DOB_MONTH] [int] NOT NULL,
[DOB_YEAR] [int] NOT NULL,
rather than DOB (datetime) ?
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day