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?