Try:

select
*
from
MyTable
where
UserID is null

--
Tom

---------------------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql


[quoted text, click to view]
HOW CAN I SELECT THE DATA FROM MYTABLE WHERE USERID = NULL ??
THANKS IN ADVANCE

Hi,

select * from MyTable where userid IS NULL

[quoted text, click to view]

Where UserId Is Null

Or Conversly

Where UserId Is Not Null


[quoted text, click to view]

HOW CAN I SELECT THE DATA FROM MYTABLE WHERE USERID = NULL ??
THANKS IN ADVANCE