RE: Query question

another way:
create a little file called ONOFF
with two fields, OOVAL (alpha 1), and OOTEXT (alpha3)
use a dfu to create the two records
0 OFF
1 ON
in the qry, join each feild that you wish to xlate
to OOVAL (you will need three joins with ONOFF),
and pick up the required OOTEXT.



At 15:57 17/08/2000 -0700, you wrote:
>Thanks. I received several similar solutions. Not what I was hoping for. I
>sure hope the simple elegant solution comes by. The file I am working with
>has at least five of these fields.
>
>
>> -----Original Message-----
>> From:        Joel Fritz [SMTP:JFritz@sharperimage.com]
>> Sent:        Thursday, August 17, 2000 2:48 PM
>> To:  'MIDRANGE-L@midrange.com'
>> Subject:     RE: Query question
>> 
>> There's probably a simple elegant solution I don't know, but...
>> 
>> I'd do two passes to an outfile, appending the results on the second pass,
>> selecting for the flag equal '1' and then '2'.  Create a result field with
>> value "On" for the query that selects '1' and change its value to "Off"
>> for
>> the query that selects '0'.  Use the result field in the outfile.  
>> 
>> Then run a third query over the outfile sorting the results the way you
>> want
>> them to appear.  
>> 
>> I'll bet someone has a better idea, though.
>> 
>> > -----Original Message-----
>> > From: Jim Cannon [mailto:JimC@Arizonabiltmore.com]
>> > Sent: Thursday, August 17, 2000 12:35 PM
>> > To: 'midrange-l@midrange.com'
>> > Subject: Query question
>> > 
>> > 
>> > I have a one byte character field that contains either '0' or 
>> > '1'. I don't
>> > want to print the character on the report. Instead I want to 
>> > print "On" for
>> > the character 1, and "Off" for the character 0.
>> > 
>> > I can't find how to do this. 
>> > 
>> > Thanks in advance
>> > 
>> > Jim Cannon 
>> > Information Systems
>> > Arizona Biltmore Resort & Spa
>> > 602-954-2569
>> > 
>> > 
>> > 
>> +---
>> | This is the Midrange System Mailing List!
>> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
>> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
>> | To unsubscribe from this list send email to
>> MIDRANGE-L-UNSUB@midrange.com.
>> | Questions should be directed to the list owner/operator:
>> david@midrange.com
>> +---
>+---
>| This is the Midrange System Mailing List!
>| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
>| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
>| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
>| Questions should be directed to the list owner/operator: david@midrange.com
>+---
>
>

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---