How to remove NULL values ?

[Avadhoot]

I've 2 columns after executing query,

one column from those 2 is calculated column.

I am getting resultset as follows



ACCOUNT ¦(calculated column)

------------------------------

100 ¦alpha

100 ¦NULL



My concern is how should I remove record with NULL from final resultset ?

If I give some name to that calculated column say 'Name'

and tried to put in main query as

"where 'Name' IS NOT NULL"; it doesnot work.

Can you have any workaround for it?

[skhanal]

Post your SQL Statement,

You should be able to do

select ...
where (calculation) is not nulll