Select Non Blank cells.

[westex96]

Hi,

I would like to select the nonblank cells in a row using the select command. This row contains several different items I need to select. How do I do that? Thank you in advance for your help!

If you use excel then you can filter by nonblank cells but my file has too many data points to use excel. : )

Cheers,

Ray

Example:

Site Event
A yes
B Maybe
C no
D
E
F

G extra
H
I Thanks
J
K

 

[PHV]

Like this ?
SELECT Site, Event
FROM yourTable
WHERE Event IS NOT NULL

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[westex96]

Thank you once again PHV!

Cheers,

Raymond