Prev: basic question re select
Next: Blocking with a View
From: AussieRules on 12 May 2010 08:28
Sorry, did the accidental keystroke for send message....oops

So how do I select records from a table where a field has a value or is
null.

I tried :

select *
from tbl_article
where lift in(1 ,null)


but that didn't work...


From: Uri Dimant on 12 May 2010 08:56
AussieRules

select *
from tbl_article
where lift =1 OR lift IS NULL


"AussieRules" <nospam(a)nospam.com> wrote in message
news:ezTLn6c8KHA.1424(a)TK2MSFTNGP04.phx.gbl...
> Sorry, did the accidental keystroke for send message....oops
>
> So how do I select records from a table where a field has a value or is
> null.
>
> I tried :
>
> select *
> from tbl_article
> where lift in(1 ,null)
>
>
> but that didn't work...
>
>


 | 
Pages: 1
Prev: basic question re select
Next: Blocking with a View