RE: Query question

[Eric Kempter <NOERICK.NORCAL@xxxxxxxxxxxxx>]

Create a physical file with two fields.  Add two records  1, ON and 0, OFF.  
Add this file to your query via a join on FLD1.  

FLD1     FLD2
0           OFF
1           ON

Hope that helps.


-----Original Message-----
From:   Jim Cannon [SMTP: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
+---