Re: Query question

[Richard Casey <casey_r@xxxxxxxxxxxxxxxx>]

Here's another 'brute force' method.

Create a two-record file with two fields.
                Field #1                Field #2
Record #1:      '0'             'Off'
Record #2:      '1'             'On'

Then join your data file to the two-record file and print Field #2.

Then there's the easy way of adding "0=Off, 1=On" as a footnote to the report!! 
:-)


> -----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
+---