Iif - Level Extreme

Level Extreme platform

Subscription

Corporate profile

Products & Services

Support

Legal

Français

Iif

Message

From

17/11/2003 07:23:52

Fabio Lunardon
Lunacom
Marostica, Italy

To

17/11/2003 07:01:19

Philip Jones
Cornwall County Council
Truro, United Kingdom

General information

Forum:

Microsoft SQL Server

Category:

SQL syntax

Title:

Re: Iif

Miscellaneous

Thread ID:

00850582

Message ID:

00850584

Views:

19

Hi,

use:

CASE ...
 WHEN ... THEN ...
 WHEN ... THEN ...
 ELSE ... -- can not put NULL on ELSE, CASE return a implicit NULL
END

Fabio

Click here to load this message in the networking platform