SQL Server
United States (English) Sign in
Home 2012 2008 R2 2008 Previous Versions Library Forums
TechNet Library
SQL Server
SQL Server 2005
Product Documentation
SQL Server 2005 Documentation
SQL Server 2005 Books Online
SQL Server Language Reference
Transact-SQL Reference
Transact-SQL Syntax Conventions (Transact-SQL)
What's New and Enhanced in Transact-SQL (Transact-SQL)
+ (Add) (Transact-SQL)
+ (Unary Plus) (Transact-SQL)
+ (String Concatenation) (Transact-SQL)
- (Negative) (Transact-SQL)
- (Subtract) (Transact-SQL)
* (Multiply) (Transact-SQL)
/ (Divide) (Transact-SQL)
% (Modulo) (Transact-SQL)
% (Wildcard - Character(s) to Match) (Transact-SQL)
& (Bitwise AND) (Transact-SQL)
| (Bitwise OR) (Transact-SQL)
^ (Bitwise Exclusive OR) (Transact-SQL)
~ (Bitwise NOT) (Transact-SQL)
= (Equals) (Transact-SQL)
> (Greater Than) (Transact-SQL)
< (Less Than) (Transact-SQL)
>= (Greater Than or Equal To) (Transact-SQL)
<= (Less Than or Equal To) (Transact-SQL)
<> (Not Equal To) (Transact-SQL)
!< (Not Less Than) (Transact-SQL)
!= (Not Equal To) (Transact-SQL)
!> (Not Greater Than) (Transact-SQL)
-- (Comment) (Transact-SQL)
/*...*/ (Comment) (Transact-SQL)
[ ] (Wildcard - Character(s) to Match) (Transact-SQL)
[^] (Wildcard - Character(s) Not to Match) (Transact-SQL)
_ (Wildcard - Match One Character) (Transact-SQL)
$PARTITION (Transact-SQL)
@@CONNECTIONS (Transact-SQL)
@@CPU_BUSY (Transact-SQL)
@@CURSOR_ROWS (Transact-SQL)
@@DATEFIRST (Transact-SQL)
@@DBTS (Transact-SQL)
@@ERROR (Transact-SQL)
@@FETCH_STATUS (Transact-SQL)
@@IDENTITY (Transact-SQL)
@@IDLE (Transact-SQL)
@@IO_BUSY (Transact-SQL)
@@LANGID (Transact-SQL)
@@LANGUAGE (Transact-SQL)
@@LOCK_TIMEOUT (Transact-SQL)
@@MAX_CONNECTIONS (Transact-SQL)
@@MAX_PRECISION (Transact-SQL)
@@NESTLEVEL (Transact-SQL)
@@OPTIONS (Transact-SQL)
@@PACK_RECEIVED (Transact-SQL)
@@PACK_SENT (Transact-SQL)
@@PACKET_ERRORS (Transact-SQL)
@@PROCID (Transact-SQL)
@@REMSERVER (Transact-SQL)
@@ROWCOUNT (Transact-SQL)
@@SERVERNAME (Transact-SQL)
@@SERVICENAME (Transact-SQL)
@@SPID (Transact-SQL)
@@TEXTSIZE (Transact-SQL)
@@TIMETICKS (Transact-SQL)
@@TOTAL_ERRORS (Transact-SQL)
@@TOTAL_READ (Transact-SQL)
@@TOTAL_WRITE (Transact-SQL)
@@TRANCOUNT (Transact-SQL)
@@VERSION (Transact-SQL)
ABS (Transact-SQL)
ACOS (Transact-SQL)
ADD SIGNATURE (Transact-SQL)
ALL (Transact-SQL)
ALTER APPLICATION ROLE (Transact-SQL)
ALTER ASSEMBLY (Transact-SQL)
ALTER ASYMMETRIC KEY (Transact-SQL)
ALTER AUTHORIZATION (Transact-SQL)
ALTER CERTIFICATE (Transact-SQL)
ALTER CREDENTIAL (Transact-SQL)
ALTER DATABASE (Transact-SQL)
ALTER ENDPOINT (Transact-SQL)
ALTER FULLTEXT CATALOG (Transact-SQL)
ALTER FULLTEXT INDEX (Transact-SQL)
ALTER FUNCTION (Transact-SQL)
ALTER INDEX (Transact-SQL)
ALTER LOGIN (Transact-SQL)
ALTER MASTER KEY (Transact-SQL)
ALTER MESSAGE TYPE (Transact-SQL)
ALTER PARTITION FUNCTION (Transact-SQL)
ALTER PARTITION SCHEME (Transact-SQL)
ALTER PROCEDURE (Transact-SQL)
ALTER QUEUE (Transact-SQL)
ALTER REMOTE SERVICE BINDING (Transact-SQL)
ALTER ROLE (Transact-SQL)
ALTER ROUTE (Transact-SQL)
ALTER SCHEMA (Transact-SQL)
ALTER SERVICE (Transact-SQL)
ALTER SERVICE MASTER KEY (Transact-SQL)
ALTER SYMMETRIC KEY (Transact-SQL)
ALTER TABLE (Transact-SQL)
ALTER TRIGGER (Transact-SQL)
ALTER USER (Transact-SQL)
ALTER VIEW (Transact-SQL)
ALTER XML SCHEMA COLLECTION (Transact-SQL)
AND (Transact-SQL)
ANY (Transact-SQL)
APPLOCK_MODE (Transact-SQL)
APPLOCK_TEST (Transact-SQL)
APP_NAME (Transact-SQL)
ASCII (Transact-SQL)
ASIN (Transact-SQL)
ASSEMBLYPROPERTY (Transact-SQL)
AsymKey_ID (Transact-SQL)
ATAN (Transact-SQL)
ATN2 (Transact-SQL)
AVG (Transact-SQL)
BACKUP (Transact-SQL)
BACKUP CERTIFICATE (Transact-SQL)
BACKUP MASTER KEY (Transact-SQL)
BACKUP SERVICE MASTER KEY (Transact-SQL)
BEGIN...END (Transact-SQL)
BEGIN CONVERSATION TIMER (Transact-SQL)
BEGIN DIALOG CONVERSATION (Transact-SQL)
BEGIN DISTRIBUTED TRANSACTION (Transact-SQL)
BEGIN TRANSACTION (Transact-SQL)
BETWEEN (Transact-SQL)
binary and varbinary (Transact-SQL)
BINARY_CHECKSUM
bit (Transact-SQL)
BREAK (Transact-SQL)
BULK INSERT (Transact-SQL)
CASE (Transact-SQL)
CAST and CONVERT (Transact-SQL)
CATCH (TRY...CATCH) (Transact-SQL)
CEILING (Transact-SQL)
CertProperty (Transact-SQL)
Cert_ID (Transact-SQL)
char and varchar (Transact-SQL)
CHAR (Transact-SQL)
CHARINDEX (Transact-SQL)
CHECKPOINT (Transact-SQL)
CHECKSUM (Transact-SQL)
CHECKSUM_AGG (Transact-SQL)
CLOSE (Transact-SQL)
CLOSE MASTER KEY (Transact-SQL)
CLOSE SYMMETRIC KEY (Transact-SQL)
COALESCE (Transact-SQL)
COLLATE (Transact-SQL)
COLLATIONPROPERTY (Transact-SQL)
COL_LENGTH (Transact-SQL)
COL_NAME (Transact-SQL)
COLUMNPROPERTY (Transact-SQL)
COLUMNS_UPDATED (Transact-SQL)
COMMIT TRANSACTION (Transact-SQL)
COMMIT WORK (Transact-SQL)
COMPUTE (Transact-SQL)
Constants (Transact-SQL)
CONTAINS (Transact-SQL)
CONTAINSTABLE (Transact-SQL)
CONTEXT_INFO (Transact-SQL)
CONTINUE (Transact-SQL)
Control-of-Flow Language (Transact-SQL)
CONVERT (Transact-SQL)
COS (Transact-SQL)
COT (Transact-SQL)
COUNT (Transact-SQL)
COUNT_BIG (Transact-SQL)
CREATE AGGREGATE (Transact-SQL)
CREATE APPLICATION ROLE (Transact-SQL)
CREATE ASSEMBLY (Transact-SQL)
CREATE ASYMMETRIC KEY (Transact-SQL)
CREATE CERTIFICATE (Transact-SQL)
CREATE CONTRACT (Transact-SQL)
CREATE CREDENTIAL (Transact-SQL)
CREATE DATABASE (Transact-SQL)
CREATE DEFAULT (Transact-SQL)
CREATE ENDPOINT (Transact-SQL)
CREATE EVENT NOTIFICATION (Transact-SQL)
CREATE FULLTEXT CATALOG (Transact-SQL)
CREATE FULLTEXT INDEX (Transact-SQL)
CREATE FUNCTION (Transact-SQL)
CREATE INDEX (Transact-SQL)
CREATE LOGIN (Transact-SQL)
CREATE MASTER KEY (Transact-SQL)
CREATE MESSAGE TYPE (Transact-SQL)
CREATE PARTITION FUNCTION (Transact-SQL)
CREATE PARTITION SCHEME (Transact-SQL)
CREATE PROCEDURE (Transact-SQL)
CREATE QUEUE (Transact-SQL)
CREATE REMOTE SERVICE BINDING (Transact-SQL)
CREATE ROLE (Transact-SQL)
CREATE ROUTE (Transact-SQL)
CREATE RULE (Transact-SQL)
CREATE SCHEMA (Transact-SQL)
CREATE SERVICE (Transact-SQL)
CREATE STATISTICS (Transact-SQL)
CREATE SYMMETRIC KEY (Transact-SQL)
CREATE SYNONYM (Transact-SQL)
CREATE TABLE (Transact-SQL)
CREATE TRIGGER (Transact-SQL)
CREATE TYPE (Transact-SQL)
CREATE USER (Transact-SQL)
CREATE VIEW (Transact-SQL)
CREATE XML SCHEMA COLLECTION (Transact-SQL)
CURRENT_REQUEST_ID (Transact-SQL)
CURRENT_TIMESTAMP (Transact-SQL)
CURRENT_USER (Transact-SQL)
cursor (Transact-SQL)
CURSOR_STATUS (Transact-SQL)
Cursors (Transact-SQL)
DATABASEPROPERTY (Transact-SQL)
DATABASEPROPERTYEX (Transact-SQL)
DATABASE_PRINCIPAL_ID (Transact-SQL)
Data Types (Transact-SQL)
DATALENGTH (Transact-SQL)
DATEADD (Transact-SQL)
DATEDIFF (Transact-SQL)
DATENAME (Transact-SQL)
DATEPART (Transact-SQL)
Date and Time (Transact-SQL)
DAY (Transact-SQL)
DB_ID (Transact-SQL)
DB_NAME (Transact-SQL)
DBCC (Transact-SQL)
DEALLOCATE (Transact-SQL)
decimal and numeric (Transact-SQL)
DECLARE @local_variable (Transact-SQL)
DECLARE CURSOR (Transact-SQL)
DecryptByAsymKey (Transact-SQL)
DecryptByCert (Transact-SQL)
DecryptByKey (Transact-SQL)
DecryptByKeyAutoAsymKey (Transact-SQL)
DecryptByKeyAutoCert (Transact-SQL)
DecryptByPassPhrase (Transact-SQL)
DEGREES (Transact-SQL)
DELETE (Transact-SQL)
DENSE_RANK (Transact-SQL)
DENY (Transact-SQL)
DIFFERENCE (Transact-SQL)
DISABLE TRIGGER (Transact-SQL)
DROP AGGREGATE (Transact-SQL)
DROP APPLICATION ROLE (Transact-SQL)
DROP ASSEMBLY (Transact-SQL)
DROP ASYMMETRIC KEY (Transact-SQL)
DROP CERTIFICATE (Transact-SQL)
DROP CONTRACT (Transact-SQL)
DROP CREDENTIAL (Transact-SQL)
DROP DATABASE (Transact-SQL)
DROP DEFAULT (Transact-SQL)
DROP ENDPOINT (Transact-SQL)
DROP EVENT NOTIFICATION (Transact-SQL)
DROP FULLTEXT CATALOG (Transact-SQL)
DROP FULLTEXT INDEX (Transact-SQL)
DROP FUNCTION (Transact-SQL)
DROP INDEX (Transact-SQL)
DROP LOGIN (Transact-SQL)
DROP MASTER KEY (Transact-SQL)
DROP MESSAGE TYPE (Transact-SQL)
DROP PARTITION FUNCTION (Transact-SQL)
DROP PARTITION SCHEME (Transact-SQL)
DROP PROCEDURE (Transact-SQL)
DROP QUEUE (Transact-SQL)
DROP REMOTE SERVICE BINDING (Transact-SQL)
DROP ROLE (Transact-SQL)
DROP ROUTE (Transact-SQL)
DROP RULE (Transact-SQL)
DROP SCHEMA (Transact-SQL)
DROP SERVICE (Transact-SQL)
DROP SIGNATURE (Transact-SQL)
DROP STATISTICS (Transact-SQL)
DROP SYMMETRIC KEY (Transact-SQL)
DROP SYNONYM (Transact-SQL)
DROP TABLE (Transact-SQL)
DROP TRIGGER (Transact-SQL)
DROP TYPE (Transact-SQL)
DROP USER (Transact-SQL)
DROP VIEW (Transact-SQL)
DROP XML SCHEMA COLLECTION (Transact-SQL)
DUMP (Transact-SQL)
ELSE (IF...ELSE) (Transact-SQL)
ENABLE TRIGGER (Transact-SQL)
EncryptByAsymKey (Transact-SQL)
EncryptByCert (Transact-SQL)
EncryptByKey (Transact-SQL)
EncryptByPassPhrase (Transact-SQL)
END (BEGIN...END) (Transact-SQL)
END CONVERSATION (Transact-SQL)
ERROR_LINE (Transact-SQL)
ERROR_MESSAGE (Transact-SQL)
ERROR_NUMBER (Transact-SQL)
ERROR_PROCEDURE (Transact-SQL)
ERROR_SEVERITY (Transact-SQL)
ERROR_STATE (Transact-SQL)
EVENTDATA (Transact-SQL)
EXCEPT and INTERSECT (Transact-SQL)
EXECUTE AS (Transact-SQL)
EXECUTE AS Clause (Transact-SQL)
EXECUTE (Transact-SQL)
EXISTS (Transact-SQL)
EXP (Transact-SQL)
Expressions (Transact-SQL)
FETCH (Transact-SQL)
FILE_ID (Transact-SQL)
FILE_IDEX (Transact-SQL)
FILE_NAME (Transact-SQL)
FILEGROUP_ID (Transact-SQL)
FILEGROUP_NAME (Transact-SQL)
FILEGROUPPROPERTY (Transact-SQL)
FILEPROPERTY (Transact-SQL)
float and real (Transact-SQL)
FLOOR (Transact-SQL)
fn_get_sql (Transact-SQL)
fn_helpcollations (Transact-SQL)
fn_listextendedproperty (Transact-SQL)
fn_my_permissions (Transact-SQL)
fn_servershareddrives (Transact-SQL)
fn_trace_geteventinfo (Transact-SQL)
fn_trace_getfilterinfo (Transact-SQL)
fn_trace_getinfo (Transact-SQL)
fn_trace_gettable (Transact-SQL)
fn_virtualfilestats (Transact-SQL)
fn_virtualservernodes (Transact-SQL)
FOR Clause (Transact-SQL)
FORMATMESSAGE (Transact-SQL)
FREETEXT (Transact-SQL)
FREETEXTTABLE (Transact-SQL)
FROM (Transact-SQL)
FULLTEXTCATALOGPROPERTY (Transact-SQL)
FULLTEXTSERVICEPROPERTY (Transact-SQL)
Functions (Transact-SQL)
GET CONVERSATION GROUP (Transact-SQL)
GET_TRANSMISSION_STATUS (Transact-SQL)
GETANSINULL (Transact-SQL)
GETDATE (Transact-SQL)
GETUTCDATE (Transact-SQL)
GO (Transact-SQL)
GOTO (Transact-SQL)
GRANT (Transact-SQL)
GROUP BY (Transact-SQL)
GROUPING (Transact-SQL)
HAS_DBACCESS (Transact-SQL)
Has_Perms_By_Name (Transact-SQL)
HashBytes (Transact-SQL)
HAVING (Transact-SQL)
Hints (Transact-SQL)
HOST_ID (Transact-SQL)
HOST_NAME (Transact-SQL)
IDENT_CURRENT (Transact-SQL)
IDENT_INCR (Transact-SQL)
IDENT_SEED (Transact-SQL)
IDENTITY (Function) (Transact-SQL)
IDENTITY (Property) (Transact-SQL)
IF...ELSE (Transact-SQL)
image (Transact-SQL)
IN (Transact-SQL)
INDEXKEY_PROPERTY (Transact-SQL)
INDEXPROPERTY (Transact-SQL)
INDEX_COL (Transact-SQL)
INSERT (Transact-SQL)
int, bigint, smallint, and tinyint (Transact-SQL)
INTO Clause (Transact-SQL)
IS_MEMBER (Transact-SQL)
IS_SRVROLEMEMBER (Transact-SQL)
ISDATE (Transact-SQL)
IS [NOT] NULL (Transact-SQL)
ISNULL (Transact-SQL)
ISNUMERIC (Transact-SQL)
Key_GUID (Transact-SQL)
Key_ID (Transact-SQL)
KILL (Transact-SQL)
KILL QUERY NOTIFICATION SUBSCRIPTION (Transact-SQL)
KILL STATS JOB (Transact-SQL)
LEFT (Transact-SQL)
LEN (Transact-SQL)
LIKE (Transact-SQL)
LOAD (Transact-SQL)
LOG (Transact-SQL)
LOG10 (Transact-SQL)
LOGINPROPERTY (Transact-SQL)
LOWER (Transact-SQL)
LTRIM (Transact-SQL)
MAX (Transact-SQL)
MIN (Transact-SQL)
MIN_ACTIVE_ROWVERSION (Transact-SQL)
money and smallmoney (Transact-SQL)
MONTH (Transact-SQL)
MOVE CONVERSATION (Transact-SQL)
NCHAR (Transact-SQL)
nchar and nvarchar (Transact-SQL)
NEWID (Transact-SQL)
NEWSEQUENTIALID()
NOT (Transact-SQL)
ntext, text, and image (Transact-SQL)
NTILE (Transact-SQL)
NULLIF (Transact-SQL)
numeric (Transact-SQL)
OBJECT_DEFINITION (Transact-SQL)
OBJECT_ID (Transact-SQL)
OBJECT_NAME (Transact-SQL)
OBJECT_SCHEMA_NAME (Transact-SQL)
OBJECTPROPERTY (Transact-SQL)
OBJECTPROPERTYEX (Transact-SQL)
OPEN (Transact-SQL)
OPEN MASTER KEY (Transact-SQL)
OPEN SYMMETRIC KEY (Transact-SQL)
OPENDATASOURCE (Transact-SQL)
OPENQUERY (Transact-SQL)
OPENROWSET (Transact-SQL)
OPENXML (Transact-SQL)
Operators (Transact-SQL)
OPTION Clause (Transact-SQL)
OR (Transact-SQL)
ORDER BY Clause (Transact-SQL)
ORIGINAL_LOGIN (Transact-SQL)
OUTPUT Clause (Transact-SQL)
OVER Clause (Transact-SQL)
PARSENAME (Transact-SQL)
PATINDEX (Transact-SQL)
PERMISSIONS (Transact-SQL)
PI (Transact-SQL)
POWER (Transact-SQL)
Predicate (Transact-SQL)
PRINT (Transact-SQL)
PUBLISHINGSERVERNAME (Transact-SQL)
QUOTENAME (Transact-SQL)
RADIANS (Transact-SQL)
RAISERROR (Transact-SQL)
RAND (Transact-SQL)
RANK (Transact-SQL)
READTEXT (Transact-SQL)
real (Transact-SQL)
RECEIVE (Transact-SQL)
RECONFIGURE (Transact-SQL)
REPLACE (Transact-SQL)
REPLICATE (Transact-SQL)
Reserved Keywords (Transact-SQL)
RESTORE Statements for Restoring, Recovering, and Managing Backups
RESTORE MASTER KEY (Transact-SQL)
RESTORE SERVICE MASTER KEY (Transact-SQL)
RETURN (Transact-SQL)
REVERSE (Transact-SQL)
REVERT (Transact-SQL)
REVOKE (Transact-SQL)
RIGHT (Transact-SQL)
ROLLBACK TRANSACTION (Transact-SQL)
ROLLBACK WORK (Transact-SQL)
ROUND (Transact-SQL)
ROWCOUNT_BIG (Transact-SQL)
ROW_NUMBER (Transact-SQL)
RTRIM (Transact-SQL)
SAVE TRANSACTION (Transact-SQL)
SCHEMA_ID (Transact-SQL)
SCHEMA_NAME (Transact-SQL)
SCOPE_IDENTITY (Transact-SQL)
Search Condition (Transact-SQL)
SELECT @local_variable (Transact-SQL)
SELECT (Transact-SQL)
SEND (Transact-SQL)
SERVERPROPERTY (Transact-SQL)
SESSION_USER (Transact-SQL)
SESSIONPROPERTY (Transact-SQL)
SET @local_variable (Transact-SQL)
SET (Transact-SQL)
SETUSER (Transact-SQL)
SHUTDOWN (Transact-SQL)
SIGN (Transact-SQL)
SignByAsymKey (Transact-SQL)
SignByCert (Transact-SQL)
SIN (Transact-SQL)
smalldatetime (Transact-SQL)
smallint (Transact-SQL)
smallmoney (Transact-SQL)
SOME | ANY (Transact-SQL)
SOUNDEX (Transact-SQL)
SPACE (Transact-SQL)
sql_variant (Transact-SQL)
SQL_VARIANT_PROPERTY (Transact-SQL)
SQRT (Transact-SQL)
SQUARE (Transact-SQL)
STATS_DATE (Transact-SQL)
STDEV (Transact-SQL)
STDEVP (Transact-SQL)
STR (Transact-SQL)
STUFF (Transact-SQL)
SUBSTRING (Transact-SQL)
SUM (Transact-SQL)
SUSER_ID (Transact-SQL)
SUSER_NAME (Transact-SQL)
SUSER_SID (Transact-SQL)
SUSER_SNAME (Transact-SQL)
System Stored Procedures (Transact-SQL)
System Tables (Transact-SQL)
System Views (Transact-SQL)
sys.fn_builtin_permissions (Transact-SQL)
sys.fn_translate_permissions (Transact-SQL)
sys.login_token (Transact-SQL)
sys.user_token (Transact-SQL)
SYSTEM_USER (Transact-SQL)
table (Transact-SQL)
TAN (Transact-SQL)
TERTIARY_WEIGHTS
text (Transact-SQL)
TEXTPTR (Transact-SQL)
TEXTVALID (Transact-SQL)
timestamp (Transact-SQL)
tinyint (Transact-SQL)
TOP (Transact-SQL)
Trace Flags (Transact-SQL)
Transactions (Transact-SQL)
TRY...CATCH (Transact-SQL)
TRIGGER_NESTLEVEL (Transact-SQL)
TRUNCATE TABLE (Transact-SQL)
TYPE_ID (Transact-SQL)
TYPE_NAME (Transact-SQL)
TYPEPROPERTY (Transact-SQL)
UNICODE (Transact-SQL)
UNION (Transact-SQL)
uniqueidentifier (Transact-SQL)
UPDATE (Transact-SQL)
UPDATE() (Transact-SQL)
UPDATE STATISTICS (Transact-SQL)
UPDATETEXT (Transact-SQL)
UPPER (Transact-SQL)
USE (Transact-SQL)
USER (Transact-SQL)
USER_ID (Transact-SQL)
USER_NAME (Transact-SQL)
VAR (Transact-SQL)
varbinary (Transact-SQL)
varchar (Transact-SQL)
VARP (Transact-SQL)
VerifySignedByCert (Transact-SQL)
VerifySignedByAsmKey (Transact-SQL)
WAITFOR (Transact-SQL)
WHERE (Transact-SQL)
WHILE (Transact-SQL)
WITH common_table_expression (Transact-SQL)
WITH XMLNAMESPACES (Transact-SQL)
WRITETEXT (Transact-SQL)
XACT_STATE (Transact-SQL)
xml (Transact-SQL)
xml_schema_namespace (Transact-SQL)
YEAR (Transact-SQL)
Expand Minimize
6 out of 19 rated this helpful - Rate this topic

IS [NOT] NULL (Transact-SQL)

SQL Server 2005

Determines whether a specified expression is NULL.

Topic link icon Transact-SQL Syntax Conventions

Copy 

expression IS [ NOT ] NULL
expression

Is any valid expression.

NOT

Specifies that the Boolean result be negated. The predicate reverses its return values, returning TRUE if the value is not NULL, and FALSE if the value is NULL.

If the value of expression is NULL, IS NULL returns TRUE; otherwise, it returns FALSE.

If the value of expression is NULL, IS NOT NULL returns FALSE; otherwise, it returns TRUE.

To determine whether an expression is NULL, use IS NULL or IS NOT NULL instead of comparison operators (such as = or !=). Comparison operators return UNKNOWN when either or both arguments are NULL.

Boolean

The following example returns the name and the weight for all products for which either the weight is less than 10 pounds or the color is unknown, or NULL.

Copy 
USE AdventureWorks;
GO
SELECT Name, Weight, Color
FROM Production.Product
WHERE Weight < 10.00 OR Color IS NULL
ORDER BY Name;
GO
Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft
|
Site Feedback
© 2013 Microsoft. All rights reserved.