| Date: | Tue, 19 Jun 2001 09:51:38 -0700 |
|---|
| Reply-To: | c-Jeff.Voeller@wcom.com |
|---|
| Sender: | "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU> |
|---|
| From: | Jeff Voeller <c-Jeff.Voeller@WCOM.COM> |
|---|
| Subject: | Re: DB2 (MVS) - EBCDIC/ASCII problem ? |
|---|
|
| In-Reply-To: | <30f37644.0106190829.414bc2d@posting.google.com> |
|---|
| Content-type: | text/plain; charset=iso-8859-1 |
|---|
On Tuesday, June 19, 2001 at 9:30 AM, Graham Dodswroth wrote:
> If I try using the following 'where' clause to achieve this it doesn't
> seem to work - i.e. the syntax seems to be correct but the blank
> character on the DB2 table is not recognised as the same as the blank
> character I type in on my PC.
>
> Where Stat2 = ' '
My DB2 memory is rusty, but I think you need something along the lines of:
WHERE STAT2 IS NULL
|
