selecting all fields with a null value

hi,
Ihaev the below sql script,

SELECT t_newsID,dtm_date,str_title,str_body,flg_archived, flg_active,flg_NIB FROM tbl_News WHERE (flg_archived=0 or flg_archived=1)

I wish though to select all records where intBranchID = null thus not selecting those where intBranchID is a numeric value.

My selection doesnt seem to work if I use FROM tbl_News WHERE (flg_archived=0 or flg_archived=1) AND intBranchID= " "

How do i script this please.
My field in db is showing NULL

cheers

Steve

This is how you check for null:

SELECT t_newsID,dtm_date,str_title,str_body,flg_archived, flg_active,flg_NIB 
FROM tbl_News 
WHERE (flg_archived=0 or flg_archived=1)
   AND intBranchID IS NULL

Nulls are special values. They are different to " ", which is a space, and they are even different to "", the empty string. To check for nulls use IS NULL:
WHERE (flg_archived=0 or flg_archived=1) AND intBranchID IS NULL

EDIT: Darn, only a few seconds between us,....