Hi

I have this SQL statement.

SELECT
VARER.PLU_NR,
VARER_DETAIL.ANTALSTK,
VARER_DETAIL.AFDELING_ID,
/* Solgt antal ATD*/
(
Select SUM(Varer_Omsetning.Antal) From
Varer_Omsetning
Where

((Varer_Omsetning.aar*100)+Varer_Omsetning.mdr)>=(:PFraPeriode) and

((Varer_Omsetning.aar*100)++Varer_Omsetning.mdr)<=(:PTIlPeriode) and
(Varer_Omsetning.Afdeling_ID=Varer_detail.afdeling_ID) and
(Varer_omsetning.vareplu_id=Varer.plu_nr)

having
SUM(Varer_Omsetning.Antal)>8 and (not
(SUM(Varer_Omsetning.Antal) is null))

) As Antal
FROM VARER_DETAIL
INNER JOIN VARER ON (VARER_DETAIL.VAREPLU_ID = VARER.PLU_NR)
GROUP BY
VARER.PLU_NR,
VARER_DETAIL.AFDELING_ID,
VARER_DETAIL.ANTALSTK
Order By VARER_detail.AntalStk Asc


This (in my small DB) returns i.e.:

011439 -262 001 60
112352 -162 001 NULL

Can I add something to the above SQL the make the line with the NULL
value NOT being returned ?

Regards
Michael