Hi ALZ

1.select count(*) as newcol_NULL_count

from yourtable

where newcol is null ;

if i implement above query it shows the follwing error

Incorrect syntax near '_NULL_Count'.

and i changed the query

2.select count(*) as newcol from yourtable where newcol is null;

it shows

newcol

------

5999