counting a non empty or null cell

[pelegk2]

i have this query :

SELECT sum(weight)as weight,
             Count(TEUDAT_MISH) as total_TEUDAT_MISH 
             from order_header 
            where del_id=4018

i want to sum all the weight - and that woks find!
the point is that i want to count TEUDAT_MISH - but the thing is that in some of the rows there maybe not a TEUDAT_MISH,
whcih mean the cells hold NULL or 0 !!!!
(if there is a TEUDAT_MISH then TEUDAT_MISH is a string of at least 6 chars!!!)

what do i nee to change in the select so it wil lwork fine!
thnaks i nadvance
peleg

[laserlight]

Then use COUNT(*) instead.

[pelegk2]

gave more incorrect answer

[laserlight]

gave more incorrect answer

Then that implies that you're not looking for the right thing.

Given that TEUDAT_MISH is a column in the table order_header.
Counting all rows with TEUDAT_MISH, including NULL rows, is equivalent to counting all the rows in order_header, including NULL rows.