Queries are not seeing NULL Values in my DB

For some reason my Stored Procs are not recognizing NULL values within my database:
For example:
Select *
From Results
Where
(
home_Phone IS NULL
)
All the home_Phone vaules that are NULL are not being picked up by the query.
Any ideas are appriciated.
Thanks in advance everyone.
RB

Perhaps rather than NULL, the home_Phone is blank (a different thing). That is, rather than NULL, the field is an empty string.|||

Are you sure the values are NULL and not a blank?

Try where home_phone = '' to be sure.

Nick

|||All SQL Server Aggregate Functions ignore NULL except COUNT(*). Hope this helps.|||

Caddre wrote:

All SQL Server Aggregate Functions ignore NULL except COUNT(*).

I am confused. How is that query using an aggregate function?
|||I am not saying the query is using aggregate function I was just telling the user about NULL value behavior in SQL server. I should have explained in detail and did not intend to confuse the user.|||

Thanks everyone for your responses its working very well.

Regards

RB