selecting records

[wxdqz]

I want to select those rows whose value is not null. In other words, there is this company whose shares is traded today so the stock value is not null today; but maybe tommorrow, the shares of that company is not traded but the company's name is in the database which i don't want to show when the value is null. Please help