Hi, suppose I have a table

Match play score

xx John 10
yy Smith
zz Paul 5

The "score" column is a Integer column, but it could be empty. How can
I select the rows that score is not empty?

Thanks,
fireman

On 2010-11-02 20:31, fireman wrote:
If by empty you mean null, then:

where score is not null

OTOH, if score is always positive:

where score >= 0

will also do.

/Lennart

On Tue, 02 Nov 2010 12:31:29 -0700, fireman wrote:

Last time someone has directed you to read the documentation. This is
really a trivial question that shouldn't have been asked on this forum.
Asking such trivial questions makes the forum unreadable and makes people
wasting their valuable time. There are plenty of "novice" mailing lists,
such questions should be sent there.



--
http://mgogala.byethost5.com