I am trying to select from a column which contains some null entries, and return only those results which are "not null". Can anyone give me some idea, as I am not having any success.
Table Users
UserID
1111
2222
4444
5555
6666
select UserID
from Users
where ??
So in this example above, I want to return just(1111,2222,4444,5555,6666), and not have the two blank spaces included in the results.
Returning "NOT NULL" set
Posted - 02/07/2006 : 05:48:56
