| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> comp.databases.theory -> Re: Mixed, or conditional, datatypes
On Mar 25, 6:14 am, "sinister" <sinis..._at_nospam.invalid> wrote:
> Example: suppose I'm storing responses to a diagnostic interview. One of
> the questions asked of the subject is something like
>
> 7. Have you always lived in the US?
>
> 7a. If the answer to 7 is "no," how many years have you lived in the US?
Why don't you just ask
7*. How many years have you lived in the US?
Then subtract this number from persons age, to get the answer to question #7.
As many folks aren't really familiar with the concept of 0, then you have to add a footnote: "(Enter 0 if you never lived in the US)" Received on Mon Mar 26 2007 - 13:47:27 CDT
![]() |
![]() |