Re: *BLANKS = spaces?

["David Keck" <dkeck@xxxxxxx>]

Carel,
    A blank is a space.  Your say ...

> I wrote SELECT * FROM file WHERE field = ' ' (one space) and I got no
result.
> Then I tried SELECT * FROM file WHERE field < ' ' (one space) and the two
records
> were returned.

In this case it is likely that the two records returned by your second SQL
statement had the "field" populated with a value between x'00 and x'39', but
not a x'40', which is a blank.  Some hex values will "appear" as a blank on
the screen, but as your first SQL statement shows, they are not actually
blank.
-DaveK

----- Original Message -----
From: Carel Teijgeler <teygeler@bart.nl>
To: <RPG400-L@midrange.com>
Sent: Friday, September 15, 2000 11:36 AM
Subject: Re: *BLANKS = spaces?


> Douglas Handy wrote:
>
> > It is the same.  There is no difference between a "blank" and a
> > "space" -- they are synonyms for x'40' in EBCDIC.
> >
>
> Not completely true, I fear.
>
> I once did an SQL on a file to retrieve two records that were not
correctly
> filled. One character field in those records was empty in comparison to
the rest
> of the records.
>
> I wrote SELECT * FROM file WHERE field = ' ' (one space) and I got no
result.
> Then I tried SELECT * FROM file WHERE field < ' ' (one space) and the two
records
> were returned.
>
> You would expect spaces, but they were *BLANKS.
>
> Carel.
>
>
>
> +---
> | This is the RPG/400 Mailing List!
> | To submit a new message, send your mail to RPG400-L@midrange.com.
> | To subscribe to this list send email to RPG400-L-SUB@midrange.com.
> | To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
david@midrange.com
> +---
>

+---
| This is the RPG/400 Mailing List!
| To submit a new message, send your mail to RPG400-L@midrange.com.
| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---