RE: Query question

ROTFLMAO! I like the 'easy way' better!

Thanks

> -----Original Message-----
> From: Richard Casey [SMTP:casey_r@popmail.firn.edu]
> Sent: Thursday, August 17, 2000 3:41 PM
> To:   MIDRANGE-L (E-mail)
> Subject:      Re: Query question
> 
> 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
> +---
+---
| 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
+---