Re: Brief query puzzle
From: Chris Jack <chrisj_at_pro-data.demon.co.uk>
Date: Fri, 31 Dec 1993 11:59:43 +0000
Message-ID: <757339183snz_at_pro-data.demon.co.uk>
Date: Fri, 31 Dec 1993 11:59:43 +0000
Message-ID: <757339183snz_at_pro-data.demon.co.uk>
In article <brantner.6.000A1F60_at_pbox.joanneum.ac.at> brantner_at_pbox.joanneum.ac.at writes:
>In article <1993Dec20.020805.13750_at_beau.atlanta.dg.com> klm_at_atlanta.dg.com (Kim
> Medlin) writes:
>>From: klm_at_atlanta.dg.com (Kim Medlin)
>>Subject: Brief query puzzle
>>Date: Mon, 20 Dec 93 02:08:05 GMT
>>I'd like to write a query that returns a status code value as it is
>>stored in the database UNLESS the current system date falls outside
>>of two date attributes that are in the same table, in which case
>>return an "X" for the status code value.
There must be an _at_ function (probably called if) that allows you to do this straightforwardly. Sorry, don't have the manual to look it up.
-- Chris JackReceived on Fri Dec 31 1993 - 12:59:43 CET