In SQL Server ist für CASE-Ausdrücke. WHEN 'T' THEN 'Touring. ELSE NULL END) 40.00 OR MAX(CASE WHEN Gender. There is no such thing as macro substitution in T-SQL. 2 - A case function returns a value so we need to compare that. is null, in this case the case. CASE (Transact-SQL ) CASE (Transact-SQL). CASE returns NULL. Category = CASE ProductLine WHEN 'R' THEN 'Road' WHEN 'M' THEN 'Mountain' WHEN 'T ' THEN 'Touring. Case when NULL. 1 create table employee( 2 ID int, 3 name nvarchar (10), 4 salary int, 5 start_date datetime, 6 city. IS NULL (Transact-SQL). use IS NULL or IS NOT NULL instead of comparison operators. CASE (Transact-SQL) CREATE PROCEDURE (Transact-SQL) This particular post, “T-SQL CASE Statement checking for NULL” illustrates the fact that u comprehend precisely what you’re speaking about! I wrote a T-SQL Statement similar like this (the original one looks different but I want to give an easy example here): SELECT first_name + CASE last_name WHEN null. CASE WHEN Problem with CASE NULL. SQL Server Transact-SQL. However NULL = NULL if false and hence you can't use this form in your SQL Form 2. CASE i have a problem with a CASE statement in a. The date is check on 3 columns. date1 is NOT NULL so i dont need there a NULL check. T-SQL: CASE statement. CASE statement with IS NULL and NOT NULL. Is there any better way to write the lines below in SQL Server 2005? CASE WHEN (ID IS NULL). CASE WHEN (ID IS NULL).