Re: Query question

["John Taylor" <john.taylor@xxxxxxxxxxxxxxx>]

Jim,

I'm assuming that you're trying to do this in Query/400 as opposed to RPG?
If so, create an SQL view over the file like this:

Create View MYLIB/MYVIEW
            ( FIELD1, FIELD2, ONOFF )
As Select
            FIELD1, FIELD2,
                Case When FIELD3='1'
                    Then 'On'
                     Else 'Off'
                 End
    From SOMELIB/SOMEFILE

Then change your query to use the view instead of the physical file, and
your problem is solved.


Regards,

John Taylor
Canada

----- Original Message -----
From: "Jim Cannon" <JimC@Arizonabiltmore.com>
To: <midrange-l@midrange.com>
Sent: Thursday, August 17, 2000 13:35
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
+---