Re: SELECT of archive files with null descriptions
1998-10-05 13:12:55
Subject: |
Re: SELECT of archive files with null descriptions |
From: |
"Price, Robert R." <pricerr AT WESTINGHOUSE DOT COM> |
Date: |
Mon, 5 Oct 1998 13:12:55 -0400 |
A variation on your suggestion worked !!! I used: "description is null",
with a space between "is" and "null".
Thanks for your help.
> ----------
> From: Steve Harrison[SMTP:sharris1 AT ISMA DOT COM]
> Sent: Monday, October 05, 1998 12:20 PM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: SELECT of archive files with null descriptions
>
> Robert Wrote:
>
>
>
> To you SELECT gurus out there...
>
> The following SELECT statement works fine for me to list all archives done
> from a client:
>
> SELECT hl_name,ll_name,description from archives where node_name='SCCAT"
> and
> type='FILE'
>
> When I try to list only those files with a certain description, the
> following works great:
>
> SELECT hl_name,ll_name,description from archives where node_name='SCCAT"
> and
> type='FILE' and description='MY ARCHIVES'
>
> Now, I am stumped on how to list those archives with a null description
> (from when this client was at Version 2). I have tried:
>
> SELECT hl_name,ll_name,description from archives where node_name='SCCAT"
> and
> type='FILE' and description=''
>
> SELECT hl_name,ll_name,description from archives where node_name='SCCAT"
> and
> type='FILE' and description=' '
>
> Any suggestions???
>
> I believe U have to check for description=isnull or maybe
> description=null.
> I had the same problem trying to check for blank version numbers awhile
> back. If this does not work, I will check at home for the answer ... I
> emailed my home so I would always have the answer no matter where I was
> working ... ; )
>
|
<Prev in Thread] |
Current Thread |
[Next in Thread>
|
- SELECT of archive files with null descriptions, Price, Robert R.
- Re: SELECT of archive files with null descriptions, Steve Harrison
- Re: SELECT of archive files with null descriptions,
Price, Robert R. <=
- Re: SELECT of archive files with null descriptions, Dale M Mock
- Re: SELECT of archive files with null descriptions, Laurence Holley
- Re: SELECT of archive files with null descriptions, Pete Tanenhaus
- Re: SELECT of archive files with null descriptions, Pat Randall
- Re: SELECT of archive files with null descriptions, Dave Crockett
- Re: SELECT of archive files with null descriptions, Michael Truty
- Re: SELECT of archive files with null descriptions, Monte Ambrose
- Re: SELECT of archive files with null descriptions, Cynthia Behrens
- Re: SELECT of archive files with null descriptions, Bob La Brie
- Re: SELECT of archive files with null descriptions, J. O'Neall
|
|
|