Select Query does not display record if field has null value and Raise Exception Stored Procedure

Hi,

I am working on MSSQL 2005

How can we use Raise Error in Stored Procedure

My query is not giving me record I did not understand the reason

In table t1 I have field status

In status filed there can be different different values like

ERROR
INSERTED
or this field (status) field can be NULL

Now when I write select query

select * from t1 where status <> 'ERROR' -- (Not Equal to ERROR)

then this does not display records where status is null

What is the reason, what I have to do so that it works

Many Thanks