test with null content

Thread View: borland.public.interbase.sql

4 messages

[T] Back to Threads [V] Tree View [G] Group Articles

4 total messages Started by Adalberto Baldini Fri, 20 Jun 2008 06:50

#249

Author: Adalberto Baldini
Date: Fri, 20 Jun 2008 06:50

12 lines
1261 bytes

In a where clause I have :

.. and not (flart = '1') ..

with flart = null test fails.

Do I need to change it in :

  and (flart is not null) and (not flart = '1')  ?

Thanks
Adalberto Baldini

Re: test with null content

#250

Author: Adalberto Baldini
Date: Fri, 20 Jun 2008 06:56

8 lines
1295 bytes

.. and not (flart = '1') ..

right test should be

and (((flart is not null) and (not flart = '1')) or
       (flart is null))

Adalberto

Re: test with null content

#251

Author: Karol Bieniaszewski
Date: Fri, 20 Jun 2008 08:41

21 lines
1412 bytes

Uzytkownik "Adalberto Baldini" <finman@swissonline.ch> napisal w wiadomosci 
news:485b5341@newsgroups.borland.com...
> In a where clause I have :
>
> .. and not (flart = '1') ..
>
> with flart = null test fails.
>
> Do I need to change it in :
>
>  and (flart is not null) and (not flart = '1')  ?
>
> Thanks
> Adalberto Baldini

what do you mean "fails"?

you test flart<>'1' ???

Karol Bieniaszewski

Re: test with null content

#252

Author: Bill Todd [TeamB]
Date: Fri, 20 Jun 2008 17:24

17 lines
1337 bytes

Adalberto Baldini wrote:

> .. and not (flart = '1') ..
> 
> right test should be
> 
> and (((flart is not null) and (not flart = '1')) or
>       (flart is null))
> 
> Adalberto

That  is correct. Null is a state meaning that there is no value. Null
is not equal to anything. Any test for equality that includes null will
be false.

-- 
Bill Todd (TeamB)

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads