Re: Query question

[Carel Teijgeler <teygeler@xxxxxxx>]

Jim Cannon wrote:

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

Try
SELECT field 1, field 2, OFF  FROM file WHERE byte1 = '0'
UNION
SELECT  field 1, field 2, ON  FROM file WHERE byte1 = '1'
ORDER BY field 1

This may do it,

Carel


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